Table schema:
CREATE TABLE phone (Accreditation_type VARCHAR)

Question: Find the number of phones for each accreditation type.
SQL: SELECT Accreditation_type, COUNT(*) FROM phone GROUP BY Accreditation_type