instruction: Return a bar chart showing how many customers whose contact channel code is email for each weekday, and could you display by the how many active from date in descending?
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' ORDER BY COUNT(active_from_date) DESC