con2.py

# find the distribution of website sessions in morning, afternoon, evening and night 
%%sql
result << 
SELECT 
    CASE
        WHEN HOUR(created_at) BETWEEN 7 AND 12 THEN 'morning'
        WHEN HOUR(created_at) BETWEEN 12 AND 16 THEN 'afternoon'
        WHEN HOUR(created_at) BETWEEN 16 AND 20 THEN 'evening'
        ELSE 'night'
    END AS divide,
    COUNT(DISTINCT website_session_id) AS sessions
FROM
    orders
GROUP BY divide;

result = result.DataFrame()

px.bar(data_frame=result, x = 'divide', y = 'sessions', template='presentation')