instruction: Show each premise type and the number of premises in that type Visualize by bar chart, and could you show premises_type in ascending order?
response: SELECT premises_type, COUNT(*) FROM Premises GROUP BY premises_type ORDER BY premises_type