CREATE TABLE Customer_Addresses (customer_id NUMBER, premise_id NUMBER, date_address_from DATETIME, address_type_code VARCHAR2, date_address_to DATETIME)
CREATE TABLE Products (product_id NUMBER, product_category VARCHAR2, product_name VARCHAR2)
CREATE TABLE Mailshot_Customers (mailshot_id NUMBER, customer_id NUMBER, outcome_code VARCHAR2, mailshot_customer_date DATETIME)
CREATE TABLE Order_Items (item_id NUMBER, order_item_status_code VARCHAR2, order_id NUMBER, product_id NUMBER, item_status_code VARCHAR2, item_delivered_datetime DATETIME, item_order_quantity VARCHAR2)
CREATE TABLE Premises (premise_id NUMBER, premises_type VARCHAR2, premise_details VARCHAR2)
CREATE TABLE Mailshot_Campaigns (mailshot_id NUMBER, product_category VARCHAR2, mailshot_name VARCHAR2, mailshot_start_date DATETIME, mailshot_end_date DATETIME)
CREATE TABLE Customers (customer_id NUMBER, payment_method VARCHAR2, customer_name VARCHAR2, customer_phone VARCHAR2, customer_email VARCHAR2, customer_address VARCHAR2, customer_login VARCHAR2, customer_password VARCHAR2)
CREATE TABLE Customer_Orders (order_id NUMBER, customer_id NUMBER, order_status_code VARCHAR2, shipping_method_code VARCHAR2, order_placed_datetime DATETIME, order_delivered_datetime DATETIME, order_shipping_charges VARCHAR2)

Give me a bar chart about the number of customer addresses in each premises type, and could you sort by the y-axis in descending please?
SELECT premises_type, COUNT(premises_type) FROM Customer_Addresses AS T1 JOIN Premises AS T2 ON T1.premise_id = T2.premise_id GROUP BY premises_type ORDER BY COUNT(premises_type) DESC
SELECT "premises_type", COUNT("premises_type") FROM "Customer_Addresses" "T1" JOIN "Premises" "T2" ON "T1"."premise_id" = "T2"."premise_id" GROUP BY "premises_type" ORDER BY COUNT("premises_type") DESC