Semi-Guided Project: Vehicle Model Analysis in SQL

Hi DQers,

This project is from an SQL course in the DQ Catalogue. I did it because I felt I lost touch with SQL. The course is a basic version of the one that already exists in the DQ Data Analyst path.

I did the course and the project. I really liked the River style of writing SQL introduced in this course. The project has a couple of my own questions in addition to those already in DQ. The last question is from DQ, I added the plot to highlight the findings.

Any feedback is welcome. I would love feedback on the question in section four. I don’t think the approach by DQ in the project is correct… but then again I could be wrong.

Link to the last page: Learn data science with Python and R projects

Project file:
Analysing Vehicle Model Sales dataset.ipynb (2.7 MB)

Click here to view the jupyter notebook file in a new tab