Project 2

i have attached my answers for all questions in sqlfile and excelfile and ipynb file and some screenshots.

and then i tried to get exact percentage for Q .16. but i could get same result as shown in chellange question page. also i used over partition by function it shows error. kindly provide me solution for that question.