How many customers using email as the contact channel? Group by customer name and bin active date by weekday in a stacked bar chart, I want to show by the total number in asc.
CREATE TABLE Customer_Contact_Channels (
    customer_id INTEGER,
    channel_code VARCHAR(15),
    active_from_date DATETIME,
    active_to_date DATETIME,
    contact_number VARCHAR(50)
)

CREATE TABLE Customer_Addresses (
    customer_id INTEGER,
    address_id INTEGER,
    date_address_from DATETIME,
    address_type VARCHAR(15),
    date_address_to DATETIME
)

CREATE TABLE Customer_Orders (
    order_id INTEGER,
    customer_id INTEGER,
    order_status VARCHAR(15),
    order_date DATETIME,
    order_details VARCHAR(255)
)

CREATE TABLE Customers (
    customer_id INTEGER,
    payment_method VARCHAR(15),
    customer_name VARCHAR(80),
    date_became_customer DATETIME,
    other_customer_details VARCHAR(255)
)

CREATE TABLE Products (
    product_id INTEGER,
    product_details VARCHAR(255)
)

CREATE TABLE Addresses (
    address_id INTEGER,
    address_content VARCHAR(80),
    city VARCHAR(50),
    zip_postcode VARCHAR(20),
    state_province_county VARCHAR(50),
    country VARCHAR(50),
    other_address_details VARCHAR(255)
)

CREATE TABLE Order_Items (
    order_id INTEGER,
    product_id INTEGER,
    order_quantity VARCHAR(15)
)
SELECT active_from_date, COUNT(active_from_date) FROM Customers AS t1 JOIN Customer_Contact_Channels AS t2 ON t1.customer_id = t2.customer_id WHERE t2.channel_code = 'Email' GROUP BY customer_name ORDER BY COUNT(active_from_date)
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 customers using email as the contact channel? Group by customer name and bin active date by weekday in a stacked bar chart, I want to show by the total number in asc. ### Input: CREATE TABLE Customer_Contact_Channels (
    customer_id INTEGER,
    channel_code VARCHAR(15),
    active_from_date DATETIME,
    active_to_date DATETIME,
    contact_number VARCHAR(50)
)

CREATE TABLE Customer_Addresses (
    customer_id INTEGER,
    address_id INTEGER,
    date_address_from DATETIME,
    address_type VARCHAR(15),
    date_address_to DATETIME
)

CREATE TABLE Customer_Orders (
    order_id INTEGER,
    customer_id INTEGER,
    order_status VARCHAR(15),
    order_date DATETIME,
    order_details VARCHAR(255)
)

CREATE TABLE Customers (
    customer_id INTEGER,
    payment_method VARCHAR(15),
    customer_name VARCHAR(80),
    date_became_customer DATETIME,
    other_customer_details VARCHAR(255)
)

CREATE TABLE Products (
    product_id INTEGER,
    product_details VARCHAR(255)
)

CREATE TABLE Addresses (
    address_id INTEGER,
    address_content VARCHAR(80),
    city VARCHAR(50),
    zip_postcode VARCHAR(20),
    state_province_county VARCHAR(50),
    country VARCHAR(50),
    other_address_details VARCHAR(255)
)

CREATE TABLE Order_Items (
    order_id INTEGER,
    product_id INTEGER,
    order_quantity VARCHAR(15)
) ### Response: SELECT active_from_date, COUNT(active_from_date) FROM Customers AS t1 JOIN Customer_Contact_Channels AS t2 ON t1.customer_id = t2.customer_id WHERE t2.channel_code = 'Email' GROUP BY customer_name ORDER BY COUNT(active_from_date)