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