@tutorial
tutorial
-
Published One parameter used multiple times
This example is part of the documentation on parameters, which can be found here: http:... -
Published SQL Window Function Practice Problem 3
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on us... -
Published Apple Stock Price (Monthly High)
SELECT date_trunc('month',date::timestamp) AS...istorical_stock_price GROUP BY 1 ORDER BY 1 -
Published Untitled Query
SELECT * FROM benn.fake_fact_events -
Published Untitled Query
SELECT date_trunc('day',occurred_at) AS day, ...nn.fake_fact_events GROUP BY 1 ORDER BY 1 -
Published Untitled Query
SELECT date_trunc('day', occurred_at) AS day,...nn.fake_fact_events GROUP BY 1 ORDER BY 1 -
Published XXX Case Study - Weekly Active Users
Weekly active users, rolling daily. -
Published SELECT Practice Problem 2
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on re... -
Published SQL SELECT Practice Problem 1
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on re... -
Published SQL LIMIT
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on li... -
Published SQL Comparison Operators Practice Problem 7
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on us... -
Published SQL Comparison Operators Practice Problem 6
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on us... -
Published SQL Comparison Operators Practice Problem 5
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on us... -
Published SQL Comparison Operators Practice Problem 3
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on us... -
Published SQL Comparison Operators Practice Problem 1
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on us... -
Published SQL Comparison Operators Practice Problem 2
This report is the solution to a practice problem from Mode's SQL Tutorial lesson on us... -
Published SQL Quiz - unique users per day
SELECT DATE_TRUNC('day', occurred_at) AS day,....fake_fact_events GROUP BY day ORDER BY day -
Published SQL Quiz - Wildcard search
SELECT COUNT(DISTINCT user_id) AS unique_user...ct_events WHERE event_name ilike '%control%' -
Published SQL Quiz - complet signup within 24 hours
SELECT COUNT(first.user_id) AS users FROM b...ours' WHERE first.event_name = 'create_user' -
Published SQL Quiz - unique users completing signup by company (answer 2)
SELECT u.company_id, COUNT(DISTINCT u....me = 'complete_signup' GROUP BY u.company_id