Number of days to make the first purchase with ranges

This is the third part of the exercise to calculate the number of days it takes users to make the first purchase. In this variation we’ll use ranges instead of number of days for a final report.

This data warehouse belongs to a fictional startup named Bindle. Bindle is a web and mobile app for reading books, it has subscription business model. The SQL Habit Course is based on Bindle’s story.

Bindle’s data warehouse contains everything needed to run a modern Internet company – web and mobile analytics, marketing data, AB-test data, etc.

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 is also a collection of Practice exercises (you’re looking at one atm) based on various datasets (E-commerce, Finance, etc). They’re meant to deepen your SQL and Data Analysis knowledge , prepare you for any challenge at work or a job interview.