DEV Community

Ashok Kumar
Ashok Kumar

Posted on

SQL Mini project :WC24 T20 Data Analytics

🏏 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.

sql #mysql #cricket #worldcup #dataanalytics #devproject

Top comments (0)