CREATE TABLE Customers (customer_id NUMBER, payment_method VARCHAR2, customer_name VARCHAR2, date_became_customer DATETIME, other_customer_details VARCHAR2)
CREATE TABLE Customer_Orders (order_id NUMBER, customer_id NUMBER, order_status VARCHAR2, order_date DATETIME, order_details VARCHAR2)
CREATE TABLE Customer_Addresses (customer_id NUMBER, address_id NUMBER, date_address_from DATETIME, address_type VARCHAR2, date_address_to DATETIME)
CREATE TABLE Addresses (address_id NUMBER, address_content VARCHAR2, city VARCHAR2, zip_postcode VARCHAR2, state_province_county VARCHAR2, country VARCHAR2, other_address_details VARCHAR2)
CREATE TABLE Customer_Contact_Channels (customer_id NUMBER, channel_code VARCHAR2, active_from_date DATETIME, active_to_date DATETIME, contact_number VARCHAR2)
CREATE TABLE Order_Items (order_id NUMBER, product_id NUMBER, order_quantity VARCHAR2)
CREATE TABLE Products (product_id NUMBER, product_details VARCHAR2)

How many customers using email as the contact channel? Group by customer name and bin active date by year in a stacked bar chart, display in ascending by the y-axis please.
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)
SELECT "active_from_date", COUNT("active_from_date") FROM "Customers" "t1" JOIN "Customer_Contact_Channels" "t2" ON "t1"."customer_id" = "t2"."customer_id" AND "t2"."channel_code" = 'Email' GROUP BY "customer_name" ORDER BY COUNT("active_from_date")