How many phones belongs to each accreditation type?
SELECT Accreditation_type ,  count(*) FROM phone GROUP BY Accreditation_type
count of phones by accreditation type refers to COUNT(*) GROUP BY Accreditation_type;