IPL SQL Practice Repository

Welcome to the IPL SQL Practice Repository! 🏏

This repository has been created for the sole purpose of honing my SQL skills. As an ardent cricket fan, I've chosen to dive into the vast world of the Indian Premier League (IPL) dataset. My aim is to explore, analyze, and learn SQL through meaningful questions and inquiries that reflect my cricketing curiosity.

About this Repository

In my quest to master SQL, I have meticulously examined the IPL dataset and crafted a set of intriguing questions. These questions are not just about SQL; they also reflect the burning queries of a cricket fan's heart. I've ensured that my SQL practice encompasses a wide range of topics, making it both comprehensive and meaningful.

While some questions may appear basic, they serve as building blocks for my SQL journey. Each query has been designed to add value to my cricketing knowledge while simultaneously strengthening my SQL skills.

Ongoing Learning

Learning is a continuous journey, and this repository is no exception. I am committed to expanding my SQL knowledge, and as such, I will keep adding new questions and insights as I progress. So, stay tuned for updates and feel free to contribute your own questions and ideas!

Thank you for joining me on this exciting SQL adventure through the world of cricket. Let's hit some boundaries and uncover the hidden insights within the IPL dataset together! 🏆📊

---

Happy querying! 🧐📁

Questions

1. Top 5 batsman in given season
2. Top 5 bowler(wicket Taken) in given season
3. Bowlers with most five wicket hauls in Indian Premier League
4. Top 5 team score
5. Top 5 individual score
6. Players with most centuries in Indian Premier League
7. Number of half centuries of given batter
8. Number of centuries of given batter
9. point table
10. specific batsman vs given bowler
11. top 5 run scorer of each teams
12. innings taken by given batter to complete given total run
13. Players with most sixes in Indian Premier League
14. Most maiden bowled in Indian Premier League
15. Batsman dismissed by Harbhajan most time in IPL
16. Stadium wise matches hosted in IPL
17. Team , Season wise boundaries in IPL
18. Players who has taken most catches in IPL
19. Players with most man-of-the-matches in IPL
20. Orange Cap/Purple cap holders season wise in IPL
21. Number of 200+ score per team
22. Number of finals played by team
23. Strike rate of specific batsman in specific over_type(power_play,middle_overs,death_overs)
24. Highest/Lowest scores of each season by wich team
25. Highest run scorer and highest wicket taker team of each season
26. In which overs given bowler takes most wicktes
27. How toss win impacts the match win (which team utilized the toss win most)
28. Which Player has played for most number of Teams in IPL
29. Most matches captained by players
30. Players involved in most IPL final
31. Most matches played by team on sunday
32. On which day virat kohli scored century