SELECT premises_type ,  premise_details FROM premises ORDER BY premises_type
Find the types and details for all premises and order by the premise type.
SELECT premises_type , premise_details FROM premises ORDER BY premises_type
select premises_type , premise_details from premises order by premises_type
Find the types and details for all premises and order by the premise type .