CREATE TABLE premises (premises_type VARCHAR, premise_details VARCHAR)

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" NULLS FIRST