As an alternative to generating statistics using Python and Pandas, this notebook is driven by SQL queries using the Erdgast API and Azure Data Studio. As such the notebook needs to be viewed in Azure Data Studio as only raw code will be visible on GitHub.
For a quick view there is my article on LinkedIn
This database has been built using cloud services. It is an Azure SQL Database and forms part of my study for the DP 300 Exam. All queries are written in T-SQL
Photo by Abed Ismail on Unsplash
1. Who is the most sucessful driver in a season?
2. What about the most successful constructor
3. Championships thrown away on the final race
4. Winning from the back
5. Percentage Likelihood of Winning By Qualifying Position
6. The effect of the undercut
7. It's all about consistency
8. The lack of consistency
9. Championships by Country; including most chamionships by a driver
SELECT grid as [Grid Position],
ROUND(CAST(count(*) AS FLOAT)/ (SELECT count(*) from form.results WHERE position = 1)*100,2) AS [Percentage Chance]
FROM form.results
WHERE position = 1
GROUP BY grid
ORDER by grid ASC;
- Add SQL Scripts Folder
- Python Notebook