Please generate SQL based on the query. Below, I will give you some examples

Query: Number of views on the official website this week, grouped by source channel

current_ time: 2023-03-22 11:20:31

sql: SELECT count(1) FROM events WHERE event = '$pageview' AND `date`>= '2023-03-20' AND `date`<= '2023-03-22' GROUP BY $latest_ utm_ source;

Query: Number of new friends added on WeChat last week
current_ time: 2023-03-22 11:20:31 
sql: SELECT count(DISTINCT user_id) FROM events WHERE event = '$WeComExternalAddMember' AND `date`>= '2023-03-13' AND `date`<= '2023-03-19';

The table structure given is as follows:  
Event Table:  
    CREATE TABLE events ( 
Event string, -- event name  
        user_ Id number, -- User ID  
Date date, -- the date of the event occurrence  
Time datetime, -- the time the event occurred

    );  
    Column event, enums = ['$pageview']

-- Using valid SQLite, answer the following questions for the tables provided above.

#Now, please generate SQL based on the query and beautify the output SQL format
Query: Total number of views on the official website today  
current_ time: 2023-04-20 16:17:29

sql: