All things SQL - tutorials, interview questions, and solutions

How to break down user activity by day of the week in SQL. Simple to pull, takes a few minutes to write the query, and data is easy to interpret and…
A quick lookup one-pager for common DATE functions in SQL
How to apply CASE conditional expressions to specify a result when there are multiple conditions.
A practical guide on how to locate and measure a tricky product persona of adjacent users in SQL, and challenges of getting such analysis in product…
Some simple and quick ways to apply sampling techniques for your analysis to get random users.
How to connect two tables that are not related by a foreign key relationship in PostgreSQL
How to get the most popular features, products, or user activity in SQL
See all