How many bookings did each customer make? List the customer id and the count in the scatter chart.
CREATE TABLE Customers (
    customer_id INTEGER,
    coupon_id INTEGER,
    good_or_bad_customer VARCHAR(4),
    first_name VARCHAR(80),
    last_name VARCHAR(80),
    gender_mf VARCHAR(1),
    date_became_customer DATETIME,
    date_last_hire DATETIME
)

CREATE TABLE Payments (
    payment_id INTEGER,
    booking_id INTEGER,
    customer_id INTEGER,
    payment_type_code VARCHAR(15),
    amount_paid_in_full_yn VARCHAR(1),
    payment_date DATETIME,
    amount_due DECIMAL(19,4),
    amount_paid DECIMAL(19,4)
)

CREATE TABLE Products_for_Hire (
    product_id INTEGER,
    product_type_code VARCHAR(15),
    daily_hire_cost DECIMAL(19,4),
    product_name VARCHAR(80),
    product_description VARCHAR(255)
)

CREATE TABLE Discount_Coupons (
    coupon_id INTEGER,
    date_issued DATETIME,
    coupon_amount DECIMAL(19,4)
)

CREATE TABLE View_Product_Availability (
    product_id INTEGER,
    booking_id INTEGER,
    status_date DATETIME,
    available_yn VARCHAR(1)
)

CREATE TABLE Bookings (
    booking_id INTEGER,
    customer_id INTEGER,
    booking_status_code VARCHAR(10),
    returned_damaged_yn VARCHAR(40),
    booking_start_date DATETIME,
    booking_end_date DATETIME,
    count_hired VARCHAR(40),
    amount_payable DECIMAL(19,4),
    amount_of_discount DECIMAL(19,4),
    amount_outstanding DECIMAL(19,4),
    amount_of_refund DECIMAL(19,4)
)

CREATE TABLE Products_Booked (
    booking_id INTEGER,
    product_id INTEGER,
    returned_yn VARCHAR(1),
    returned_late_yn VARCHAR(1),
    booked_count INTEGER,
    booked_amount FLOAT
)
SELECT T1.customer_id, COUNT(*) FROM Customers AS T1 JOIN Bookings AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.customer_id
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many bookings did each customer make? List the customer id and the count in the scatter chart. ### Input: CREATE TABLE Customers (
    customer_id INTEGER,
    coupon_id INTEGER,
    good_or_bad_customer VARCHAR(4),
    first_name VARCHAR(80),
    last_name VARCHAR(80),
    gender_mf VARCHAR(1),
    date_became_customer DATETIME,
    date_last_hire DATETIME
)

CREATE TABLE Payments (
    payment_id INTEGER,
    booking_id INTEGER,
    customer_id INTEGER,
    payment_type_code VARCHAR(15),
    amount_paid_in_full_yn VARCHAR(1),
    payment_date DATETIME,
    amount_due DECIMAL(19,4),
    amount_paid DECIMAL(19,4)
)

CREATE TABLE Products_for_Hire (
    product_id INTEGER,
    product_type_code VARCHAR(15),
    daily_hire_cost DECIMAL(19,4),
    product_name VARCHAR(80),
    product_description VARCHAR(255)
)

CREATE TABLE Discount_Coupons (
    coupon_id INTEGER,
    date_issued DATETIME,
    coupon_amount DECIMAL(19,4)
)

CREATE TABLE View_Product_Availability (
    product_id INTEGER,
    booking_id INTEGER,
    status_date DATETIME,
    available_yn VARCHAR(1)
)

CREATE TABLE Bookings (
    booking_id INTEGER,
    customer_id INTEGER,
    booking_status_code VARCHAR(10),
    returned_damaged_yn VARCHAR(40),
    booking_start_date DATETIME,
    booking_end_date DATETIME,
    count_hired VARCHAR(40),
    amount_payable DECIMAL(19,4),
    amount_of_discount DECIMAL(19,4),
    amount_outstanding DECIMAL(19,4),
    amount_of_refund DECIMAL(19,4)
)

CREATE TABLE Products_Booked (
    booking_id INTEGER,
    product_id INTEGER,
    returned_yn VARCHAR(1),
    returned_late_yn VARCHAR(1),
    booked_count INTEGER,
    booked_amount FLOAT
) ### Response: SELECT T1.customer_id, COUNT(*) FROM Customers AS T1 JOIN Bookings AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.customer_id