This lesson is based on theLive dataset.
Another way to visualize trends is to use line charts or bar charts .
By now we’ve written a ton of those queries, it’s a simple grouping by date and counting. We just need to spice it up with a filter relative to the current timestamp:
SELECT created_at::date AS date, COUNT(*) FROM users WHERE created_at > now() - '30 days'::interval GROUP BY 1 ORDER BY 1 DESC
Go ahead and draw a chart for that query.
This timeline query is very powerful, it’s a template for any table that contains a timestamp field (
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit.
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work.