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 (created_at
or anything_happened_at
)....
âwell worth the moneyâ
Sign up and check out 36 free lessons and exercises.
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. 