Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE mailshot_campaigns ( mailshot_id number, product_category text, mailshot_name text, mailshot_start_date time, mailshot_end_date time )
TABLE: CREATE TABLE products ( product_id number, product_category text, product_name text )
TABLE: CREATE TABLE premises ( premise_id number, premises_type text, premise_details text )
TABLE: CREATE TABLE customer_addresses ( customer_id number, premise_id number, date_address_from time, address_type_code text, date_address_to time )
TABLE: CREATE TABLE order_items ( item_id number, order_item_status_code text, order_id number, product_id number, item_status_code text, item_delivered_datetime time, item_order_quantity text )
TABLE: CREATE TABLE customer_orders ( order_id number, customer_id number, order_status_code text, shipping_method_code text, order_placed_datetime time, order_delivered_datetime time, order_shipping_charges text )
TABLE: CREATE TABLE mailshot_customers ( mailshot_id number, customer_id number, outcome_code text, mailshot_customer_date time )
TABLE: CREATE TABLE customers ( customer_id number, payment_method text, customer_name text, customer_phone text, customer_email text, customer_address text, customer_login text, customer_password text )

### Question ###
Find the types and details for all premises and order by the premise type.

### Accurate SQL ###

SELECT premises_type, premise_details FROM premises ORDER BY premises_type