Find the number of phones for each accreditation type.
SELECT Accreditation_type ,  count(*) FROM phone GROUP BY Accreditation_type
number of phones = COUNT(*); for each accreditation type refers to GROUP BY Accreditation_type;