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