Project 2
Aim: To complete Project 2 Challenge
Software Used: MySQL workbench
Solution:
- Attached are files 'Project2.ipynb', 'Project2_Challenge.xlsx', 'Project_2.sql' which contains solutions corresponding to each question of Project 2 Challenge.
- Solution of each question is marked using a comment before corresponding script.
4Ans. 'Project2.ipynb' a jupyter notebook file is attached with this report.
5Ans. Using latest version of Excel unable to import more than 100 rows.
6-11Ans. Replaced NULL values with string 'NA' in all the specified tables
12,14-16Ans. Individual Queries are given for each question & question number is mentioned before corresponding query in the attached MySQL file
13Ans. All the views are imported into the excel sheet in invidiual sheets & pivot tables have been created in the attached excel sheet.