Find the number of phones for each accreditation type.
create table phone (accreditation_type varchar, PRIMARY KEY (accreditation_type))
select accreditation_type, count(*) from phone group by accreditation_type