Find the types and details for all premises and order by the premise type.
CREATE TABLE premises (premises_type VARCHAR, premise_details VARCHAR)
[SQL] SELECT premises_type, premise_details FROM premises ORDER BY premises_type [/SQL]