Mode connects the world’s data and the people who analyze it.
Learn More
Sign In
Sign Up
@tutorial
tutorial
111
Public Reports
79
Public Tables
Reports
Tables
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
‹ Prev
1
2
3
4
…
6
Next ›