CREATE TABLE Discount_Coupons (coupon_id NUMBER, date_issued DATETIME, coupon_amount NUMBER)
CREATE TABLE Payments (payment_id NUMBER, booking_id NUMBER, customer_id NUMBER, payment_type_code VARCHAR2, amount_paid_in_full_yn VARCHAR2, payment_date DATETIME, amount_due NUMBER, amount_paid NUMBER)
CREATE TABLE Customers (customer_id NUMBER, coupon_id NUMBER, good_or_bad_customer VARCHAR2, first_name VARCHAR2, last_name VARCHAR2, gender_mf VARCHAR2, date_became_customer DATETIME, date_last_hire DATETIME)
CREATE TABLE View_Product_Availability (product_id NUMBER, booking_id NUMBER, status_date DATETIME, available_yn VARCHAR2)
CREATE TABLE Products_Booked (booking_id NUMBER, product_id NUMBER, returned_yn VARCHAR2, returned_late_yn VARCHAR2, booked_count NUMBER, booked_amount FLOAT)
CREATE TABLE Bookings (booking_id NUMBER, customer_id NUMBER, booking_status_code VARCHAR2, returned_damaged_yn VARCHAR2, booking_start_date DATETIME, booking_end_date DATETIME, count_hired VARCHAR2, amount_payable NUMBER, amount_of_discount NUMBER, amount_outstanding NUMBER, amount_of_refund NUMBER)
CREATE TABLE Products_for_Hire (product_id NUMBER, product_type_code VARCHAR2, daily_hire_cost NUMBER, product_name VARCHAR2, product_description VARCHAR2)

How many bookings did each customer make? Show the customer id as the Y-axis and the first name as the X-axis in a bar chart, and could you sort by the X-axis from low to high?
SELECT T1.first_name, T1.customer_id FROM Customers AS T1 JOIN Bookings AS T2 ON T1.customer_id = T2.customer_id ORDER BY T1.first_name
SELECT "T1"."first_name", "T1"."customer_id" FROM "Customers" "T1" JOIN "Bookings" "T2" ON "T1"."customer_id" = "T2"."customer_id" ORDER BY "T1"."first_name"