Find the types and details for all premises and order by the premise type.
create table premises (premises_type varchar, premise_details varchar, PRIMARY KEY (premises_type))
select premises_type, premise_details from premises order by premises_type