Now that you have database access let’s discuss some tips for writing and organizing your research and queries.
This one comes from a Data Analyst colleague of mine. I noticed that the first filter in all of his queries is always
1 = 1 (which is always
TRUE and doesn’t affect query results):
SELECT * FROM users WHERE 1 = 1 AND country = 'us' AND status = 'customer'
The idea is that when you’re researching something you often look at different slices of data by commenting filters out like so:
SELECT * FROM users WHERE 1 = 1 AND country = 'us' --...
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.