In this lesson, let’s talk about making the data in the warehouse more accessible.
Let’s revisit one of the queries from the AB-testing chapter:
WITH ab_test_categorization AS ( SELECT user_id, custom_parameters ->> 'ab_test_name' AS ab_test_name, custom_parameters ->> 'ab_test_variation' AS ab_test_variation, created_at AS categorized_at FROM mobile_analytics.events WHERE custom_parameters ->> 'ab_test_name' IS NOT NULL AND action = 'signup' ), ab_test_stats AS ( SELECT ab_test_variation AS variation, COUNT(DISTINCT(c.user_id))...
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. 