Example graph

Intro to SQL for Product Managers, Part 3

Please check out part 1 and part 2 if you haven’t already.

In this section, I’ll talk about a few ways to look at time when it comes to SQL queries.

Time is often an important piece of the puzzle for a product manager.

How many people have done x in the last 30 days? How many people did x within 7 days of signing up? How has our cancellation rate changed over time? How many people did x before we made a change vs after? etc.

Queries to figure out any of that require a good understanding of how to make the appropriate queries in SQL.

Continue reading