SELECT Accreditation_type ,  count(*) FROM phone GROUP BY Accreditation_type
How many phones belongs to each accreditation type?
SELECT Accreditation_type , count ( * ) FROM phone GROUP BY Accreditation_type
select accreditation_type , count ( * ) from phone group by accreditation_type
How many phones belongs to each accreditation type ?