Database: customers_campaigns_ecommerce
Question: Show each premise type and the number of premises in that type.
SQL:
SELECT premises_type ,  count(*) FROM premises GROUP BY premises_type