CREATE TABLE phone (Accreditation_type VARCHAR2)

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