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