Show each premise type and the number of premises in that type.
SELECT premises_type ,  count(*) FROM premises GROUP BY premises_type
SELECT premises_type ,  count(*) FROM premises GROUP BY premises_type
[{'premises_type': 'Office', 'count(*)': 7}, {'premises_type': 'Residence', 'count(*)': 4}, {'premises_type': 'Warehouse', 'count(*)': 4}]