CS 586: Project submission - Divya Sravani Vukkusila & Shweta Korulkar

Report with 20 questions, their queries and their output can be found HERE

List of tables and their data:

Disclaimer: With huge data, the links to view this data could take longer time than the usually expected.

DataBase Table Name	Columns count & Rows count	Link to the View the Data	Link to download the csv file
Olist_customer	5 columns & 100,000 rows	olist_customers_dataset	olist_customers_dataset.csv (8.62MB)
Olist_product	9 columns & 33,000 rows	olist_products_dataset	olist_products_dataset.csv (2.27 MB)
Olist_sellers	4 columns & 3,095 rows	olist_sellers_dataset	olist_sellers_dataset.csv (0.17 MB)
Olist_order_items	7 columns & 113,000 rows	olist_order_items_dataset	olist_order_items_dataset.csv (14.72 MB)
Olist_order_reviews	7 columns & 100,000 rows	olist_order_reviews_dataset	olist_order_reviews_dataset.csv (2.27 MB)
Olist_order_payments	5 columns & 104,000 rows	olist_order_payments_dataset	olist_order_payments_dataset.csv (5.51 MB)
Olist_product_category	2 columns & 71 rows	product_category_name_translation	product_category_name_translation.csv (2.55 KB)