Learn
Scenario: Mattresses and More sells bedding essentials from their e-commerce store. Their purchase funnel is:
- The user browses products and adds them to their cart
- The user proceeds to the checkout page
- The user enters credit card information and makes a purchase
Three steps! Simple and easy.
As a sales analyst, you want to examine data from the shopping days before Christmas. As Christmas approaches, you suspect that customers become more likely to purchase items in their cart (i.e., they move from window shopping to buying presents).
The data for Mattresses and More is spread across several tables:
browse
- each row in this table represents an item that a user has added to his shopping cartcheckout
- each row in this table represents an item in a cart that has been checked outpurchase
- each row in this table represents an item that has been purchased
Instructions
1.
Let’s examine each table. Note that each user has multiple rows representing the different items that she has placed in her cart.
SELECT * FROM browse LIMIT 5; SELECT * FROM checkout LIMIT 5; SELECT * FROM purchase LIMIT 5;
What are the column names in each table?
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.