Explore the `ic_products` 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|

[Data Source](https://www.kaggle.com/competitions/instacart-market-basket-analysis/data)

Instacart Exploration – Case Study Checkpoint #1 SQL Interview Question

Instacart Exploration – Case Study Checkpoint #1

SQL Interview Question

Table Schema

ic_order_products_curr, ic_order_products_prior

ic_products

ic_departments

ic_aisles

Solution

Column Name	Type
order_id	integer
product_id	integer
add_to_cart_order	integer
reordered	integer boolean (1 or 0)

Column Name	Type
product_id	integer
product_name	string
aisle_id	integer
department_id	integer