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
[{'Accreditation_type': 'Full', 'count(*)': 4}, {'Accreditation_type': 'Provisional', 'count(*)': 4}]