Back to questions
Instacart Exploration – Case Study Checkpoint #1 [SQL Interview Question]
Explore the data. Here are some questions to investigate:
- How many items are there?
- How many different products are in the dataset?
Table Schema
Here are the schemas for all 5 tables in the Instacart market data.
ic_order_products_curr, ic_order_products_prior
These files specify which products were purchased in each Instacart order. ic_order_products_prior contains previous order contents for all customers, and ic_order_products_curr contains current orders; the table fields are the same.
The 'reordered' field indicates that the customer has a previous order that contains the product. Other fields should be self-explanatory.
| Column Name | Type |
|---|---|
| order_id | integer |
| product_id | integer |
| add_to_cart_order | integer |
| reordered | integer boolean (1 or 0) |
Notes
- Some orders will have no reordered items
- None of these fields are unique to this table, but the combination of order_id and product is unique
ic_products
| Column Name | Type |
|---|---|
| product_id | integer |
| product_name | string |
| aisle_id | integer |
| department_id | integer |
ic_departments
| Column Name | Type |
|---|---|
| department_id | integer |
| department | string |
ic_aisles
| Column Name | Type |
|---|---|
| aisle_id | integer |
| aisle | string |
Solution
PostgreSQL 14