π World Cup 2024 Stats Analysis with MySQL:
I recently built a small side project to analyze the ICC Cricket World Cup 2024 using MySQL. The goal was to write efficient queries to explore player performances, team stats, match results, and more β all using raw SQL.
π» What I Did
Designed a simple relational schema for teams, players, matches, and performance stats
Wrote MySQL queries to:
Find top run-scorers & wicket-takers
Get win/loss summaries for each team
Analyze match results
Extract player-wise contributions
Practiced JOIN, GROUP BY, SUM, and ORDER BY for real-world analysis
π GitHub Repo
You can check out the project and the SQL queries here:
π GitHub - World Cup 2024 Stats (SQL)
(https://github.com/Ashokkumarrk/SQL-Practices.git)
βοΈ Tools Used
MySQL for all queries
Sample data manually created (can be extended using real datasets later)
π§ Why I Built This
I wanted to combine my love for cricket with learning SQL in a more practical, fun way. Sports analytics is a great playground for data lovers, and this project helped me get more confident with MySQL.
Top comments (0)