FAQ   SQL FAQ


Topic Replies Activity
Does making a "mini" dataset actually create a new table? 1 December 21, 2018
Is there another way that determining play counts of a song might have been implemented? 4 September 4, 2019
What's the difference between GROUP BY and ORDER BY? 1 December 6, 2018
How does the average function work? 1 December 11, 2018
FAQ: Usage Funnels - Build a Funnel from Multiple Tables 4 21 January 10, 2020
How are database tables separated? 1 December 21, 2018
Is there a limit to the number of columns a table can have? 1 November 22, 2018
Does casing matter when selecting the names? 5 September 23, 2019
FAQ: Multiple Tables - Review 5 January 22, 2019
Does every SQL statement follow this structure? 3 August 17, 2019
Do we have to select the column which we are ordering by in a SQL statement? 1 November 16, 2018
Why isn't there a field for whether a user is premium in the users table? 1 December 21, 2018
Are we limited to only one aggregate function per query? 1 August 4, 2018
FAQ: Multiple Tables - Introduction 2 March 26, 2019
Given a value that is not a unique identifier, can we determine a unique identifier? 1 August 24, 2018
What does strftime() do? 1 December 21, 2018
What happens if we try to create a table with an existing name? 7 January 11, 2020
FAQ: Advanced Aggregates - Reorder Rates 5 February 13, 2019
FAQ: Code Challenges - Code Challenge 1 3 January 31, 2019
FAQ: Usage Funnels - A/B Tests Results 1 October 28, 2018
FAQ: Conditional Aggregates - CASE WHEN 5 January 27, 2019
FAQ: Date, Number, and String Functions - Dates III 2 January 23, 2019
FAQ: Calculating Churn - Multiple Month: Sum Active and Canceled Users 1 October 26, 2018
FAQ: Subqueries - Table Transformation 1 October 25, 2018
FAQ: Why Learn SQL? - Begin Your Journey 1 October 27, 2018
FAQ: Why Learn SQL? - Determining Web Traffic Attribution 1 October 27, 2018
FAQ: Set Operations - Except 1 October 25, 2018
FAQ: Why Learn SQL? - Analyzing User Churn 1 October 27, 2018
FAQ: Why Learn SQL? - Exploring Data with SQL 1 October 26, 2018
FAQ: Common Metrics - 1 Day Retention 1 October 25, 2018