Show the type for all premises.
select premises_type from premises
Also add their details.
select premises_type, premise_details from premises
Order them by the premise type.
select premises_type, premise_details from premises order by premises_type