Database: customers_campaigns_ecommerce
Question: Find the types and details for all premises and order by the premise type.
SQL:
SELECT premises_type ,  premise_details FROM premises ORDER BY premises_type