SELECT TYPE ,  count(*) FROM store GROUP BY TYPE
Find all types of store and number of them.
SELECT TYPE , count ( * ) FROM store GROUP BY TYPE
select type , count ( * ) from store group by type
Find all types of store and number of them .