Average number of items per cart

E-Commerce and Data Analysis classic exercise (which is quite often used in job interviews) – calculating the average number of items per cart. It’s not an easy one but if you’re working in E-commerce (or your product has add-ons, for example) it should be your bread & butter.

This data warehouse is inspired by an E-commerce website like Amazon.

Our E-commerce website allows vendors to sell items in multiple categories. Users can add as many items as they want to a cart and then purchase a cart with/without a discount code. Users also can return items and leave reviews.

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.