How many phones belongs to each accreditation type?
select accreditation_type, count(*) from phone group by accreditation_type