➣ IPL-Sports-Analysis-Project
➣ IPL Sports Analysis Project Using PostgreSQL.
➣ IPL - Indian Premier League
๐ฌ IPL is a Professional Twenty20 Cricket League in India organised by the Board of Control for Cricket in India (BCCI).
๐ฌ Founded in 2007, The League Features ten State or city based Franchies Teams.
๐ฌ The IPL is the most Popular and richest Cricket League in the world and is held between March and May.
๐ฌ IPL League Consists of Ten Teams.
NO. | TEAM | City
(01) | Chennai Super Kings(CSK) | Chennai, Tamil Nadu
๐ญ Chennai Super Kings (CSK)
Owner : Narayanaswami Srinivas
Won : 2010, 2011, 2018, 2021, 2023
Runner-UP : 2008, 2012, 2013, 2015, 2019
(02) | Delhi Capitals(DC) | New Delhi, Delhi
๐ญ Delhi Capitals (DC)
Owner : GMR Group And JSW Sports
Runner-UP : 2020
(03) | Gujrat Titans(GT) | Ahmedabad, Gujrat
๐ญGujarat Titans (GT)
Owner : Torrent Group and CVC Capital
Won : 2022
Runner-Up :2023
(04) | Kolkat Knight Riders(KKR) | Kolkata,West Bengal
๐ญ Kolkata Knight Riders (KKR)
Owner : Shah Rukh Khan, Juhi Chawla, Jay Mehta, Red Chillies Entertainment
Won : 2012, 2014, 2024
Runner-Up :2021
(05) | Lucknow Super Giants(LSG) | Lucknow, Uttar Pradesh
๐ญ Lucknow Super Giants (LSG)
Owner : Sanjiv Goenka
(06) | Mumbai Indians(MI) | Mumbai, Maharashtra
๐ญ Mumbai Indians (MI)
Owner : Nita Ambani, Mukesh Ambani
Won : 2013, 2015, 2017, 2019, 2020
Runner-Up : 2010
(07) | Punjab Kings(PBKS) | Mullanpur, Mohali, Punjab
๐ญ Punjab Kings (PBKS)
Owner : Preity Zinta, Mohit Burman, Ness Wadia, Karan Paul
Runner-Up : 2014
(08) | Rajasthan Royals(RR) | Jaipur, Rajasthan
๐ญ Rajasthan Royals (RR)
Owner : Manoj Badale, Lachlan Murdoch
Won : 2008
Runner-Up : 2022
(09) | Sunrisers Hyderabad(SRH) | Hyderabad, Telangana
๐ญ Sunrisers Hyderabad(SRH)
Owner : Kalanithi Maran
Won : 2016
Runner-Up : 2018, 2024
(10) | Royal Challengers Bangaluru(RCB) |Bengaluru, Karnataka
๐ญ Royal Challengers Bangaluru(RCB)
Owner : United Spirits Limited
Won : 2016
Runner-Up : 2009, 2011, 2016
To Know More About the IPL League Visit Official Site
Link Here : https://en.wikipedia.org/wiki/Indian_Premier_League
For the Data_Set From There Link_There : https://www.kaggle.com/datasets/patrickb1912/ipl-complete-dataset-20082020
Visit for IPL Data sheet ON GitHub: https://github.com/kuldeep5507/IPL-Sports-Analysis-Project
(1). Find Player Whose SR is Above 120 ?
SELECT Player, Runs, BF, Against, Venue,
Match_Date
FROM Fatest_Centuries
WHERE Runs >= '120'
ORDER BY Runs DESC;
(2). To Get The Player Hit Maximum Ton Against Each IPL Franchies ?
SELECT COUNT(Player) AS Total_Player, Against
FROM Fatest_Centuries
GROUP BY Against
ORDER BY Total_Player DESC;
(3). Highest Runs In An Innings By Individual Player, With Their States ?
SELECT *
FROM Fatest_Centuries
WHERE Runs = (SELECT MAX(Runs) FROM Fatest_Centuries);
(4). Highest Dots Balls Per Innings By Individual Player, With Their States ?
SELECT *
FROM Most_Dot_Balls_Inning
WHERE Dots = (SELECT MAX(Dots) FROM Most_Dot_Balls_Inning);
(5). Named Player Who Become Highest Wicket Taker and Most Dot Ball Per Inning Against Each IPL Franchies ?
SELECT Most_Dot_Balls_Inning.Player
, Most_Dot_Balls_Inning.Dots
, Most_Wicket.Wkts
, Most_Wicket.bbi
, Most_Dot_Balls_Inning.Against
, Most_Dot_Balls_Inning.Match_Date
FROM Most_Wicket
INNER JOIN Most_Dot_Balls_Inning
ON Most_Wicket.Player = Most_Dot_Balls_Inning.Player
WHERE Most_Dot_Balls_Inning.Against = (SELECT MAX(Most_Dot_Balls_Inning.Against) FROM Most_Dot_Balls_Inning)
ORDER BY Most_Wicket.Wkts DESC;
(6). Find Out Top 5 Player Who Hit Most Sixes in a IPL Season ?
SELECT User_Id
, Player
, Mat
, Inns
, Runs
, HS
, SR
, Hundred
, fifties
, Fours
, Sixes
FROM Most_Runs
WHERE Sixes >= '30'
ORDER BY Sixes DESC
LIMIT 5;
(7). In IPL History Pick Top Player who Ton Above 150 ?
SELECT *
FROM Fatest_Centuries
WHERE Runs >= '150';
(8). --Pick Top Player Who Score A Ton Against IPL Team 'CSK' ?
SELECT Player, Runs, BF, Against, Venue, Match_Date
FROM Fatest_Centuries
WHERE Against = 'CSK'
ORDER BY Runs DESC;
(9). To Get List of Player Who Score Equal & Less Than 25 And Run Score Greater Than & Equal to 60 ?
SELECT Player
, Runs
, BF
, Against
, Venue
, Match_Date
FROM Fatest_Fifties
WHERE BF <= '25' AND Runs >= '60'
ORDER BY BF ASC;
(10). Find Out Maximum Times Player Hit Fatest Fifties against Each IPL Franchies ?
SELECT COUNT(Player) AS Total_Player
, Against
FROM Fatest_Fifties
WHERE BF <= '25' AND Runs >= '60'
GROUP BY Against
ORDER BY Total_Player DESC;
(11). Maximum Number of time A Player Hit Fatest Fifties Against IPL Franchies ?
SELECT MAX(Player) AS Total_Player
, Against
FROM Fatest_Fifties
GROUP BY Against
ORDER BY Total_Player DESC;
(12). Find Player WhO Score At Least Fifties and Centuries Against IPL Franchies ?
SELECT Fatest_fifties.Player AS Players
, Fatest_fifties.Runs AS Fifties_Runs
, Fatest_fifties.BF
, Fatest_Centuries.Runs AS Centuries_Runs
, Fatest_Centuries.BF
, Fatest_Centuries.Against
, Fatest_Fifties.Venue
, Fatest_Centuries.Match_Date
FROM Fatest_Centuries
INNER JOIN Fatest_fifties
ON Fatest_Centuries.Player = Fatest_fifties.Player
WHERE Fatest_fifties.Runs >= '80' AND Fatest_Centuries.Runs >= '130'
ORDER BY Players ASC;
(13). Pick Top 5 Player Who Hit's Fatest Centuries and Fifties Against, Venue With Match_Date ?
SELECT Fatest_fifties.Player
, Fatest_fifties.Runs
, Fatest_fifties.BF
, Fatest_Centuries.Runs
, Fatest_Centuries.BF
, Fatest_Centuries.Against
, Fatest_Fifties.Venue
, Fatest_Centuries.Match_Date
FROM Fatest_Centuries
INNER JOIN Fatest_fifties
ON Fatest_Centuries.Player = Fatest_fifties.Player
WHERE Fatest_fifties.BF = '35' OR Fatest_Centuries.BF = '35'
ORDER BY Fatest_Centuries.BF ASC, Fatest_fifties.BF ASC
LIMIT 5;
(14). Player Who Conceded Most_Four_Per_Inning By An Individual Player Against IPL Franchies with their Runs And Match Date Since 2008 to 2022. ?
SELECT Player
, Runs
, Fours
, Against
, Venue
, Match_Date
FROM Most_Four_Per_Inning
WHERE Fours = (SELECT MAX(Fours) FROM Most_Four_Per_Inning);
(15). Bowler Who Conceded Most Runs In IPL Edition Since 2008 to 2022. ?
SELECT Player
, Runs
, Wkts
, Against
, Venue
, Match_Date
FROM Most_Run_Conceded_Per_Inn
WHERE Runs = (SELECT MAX(Runs) FROM Most_Run_Conceded_Per_Inn);
(16). List of Player with Most Runs, Wkts, Against at The Wankhede Stadium in IPL. ?
SELECT Player
, Runs
, Wkts
, Against
, Venue
, Match_Date
FROM Most_Run_Conceded_Per_Inn
WHERE Runs >= '50' AND Venue = 'Wankhede Stadium'
ORDER BY Runs DESC;
(17). Bowler Who Conceded Most Runs With Most Dot Ball in IPL Since 2008 to 2022. ?
SELECT Most_Run_Conceded_Per_Inn.Player
, Most_Run_Conceded_Per_Inn.Runs
, Most_Dot_Balls_Inning.Dots
, Most_Dot_Balls_Inning.Against
, Most_Dot_Balls_Inning.Venue
, Most_Dot_Balls_Inning.Match_Date
FROM Most_Dot_Balls_Inning
INNER JOIN Most_Run_Conceded_Per_Inn
ON Most_Run_Conceded_Per_Inn.Player = Most_Dot_Balls_Inning.Player
WHERE Most_Run_Conceded_Per_Inn.Runs = (SELECT MAX(Most_Run_Conceded_Per_Inn.Runs) FROM Most_Run_Conceded_Per_Inn);
(18). Virat Kohli Hit Total Number of Four At M. Chinnaswamy Stadium. ?
SELECT SUM(Fours) AS Total_Fours
, Player
FROM Most_Four_Per_Inning
WHERE Player = 'Virat Kohli' AND Venue = 'M. Chinnaswamy Stadium'
GROUP BY Player;
(19). MS Dhoni( Yani Ki Mai 'Thala' ) Hits Maximum Number of Four Against RCB Whole The Strike Rate is Above '150' in IPL ?
SELECT MAX(Fours) AS Maximum_Fours
, Player
FROM Most_Four_Per_Inning
WHERE Player = 'MS Dhoni' AND (Against = 'RCB' OR SR >= '150')
GROUP BY Player;
(20). Find List of Player Who Runs MIN in IPL Against And Venue With UNION.
SELECT Player, Runs, Against, Venue, Match_Date FROM Fatest_Centuries WHERE Runs = (SELECT MIN(Runs) FROM Fatest_Centuries)
UNION
SELECT Player, Runs, Against, Venue, Match_Date FROM Fatest_Fifties WHERE Runs = (SELECT MIN(Runs) FROM Fatest_Fifties)
ORDER BY Against ASC;
(21). Pick Player Who Hit Highest_Run In A Single Over, With That Player States. ?
SELECT Player, Runs, BF, SR, Fours, Sixes, Against, Venue, Match_Date
FROM Most_Runs_Per_Over
WHERE Runs = (SELECT MAX(Runs) FROM Most_Runs_Per_Over);
(22). Player Who Hits 35 or More Than 35 Run in a Over. ?
SELECT Most_Runs.Player
, Most_Runs.Runs AS Total_Runs
, Most_Runs_Per_Over.Runs AS Per_Over_Runs
, Most_Runs_Per_Over.Fours AS Per_Over_Fours
, Most_Runs_Per_Over.Sixes AS Per_Over_Sixes
, Most_Runs_Per_Over.Against
, Most_Runs_Per_Over.Venue
, Most_Runs_Per_Over.Match_Date
FROM Most_Runs
INNER JOIN Most_Runs_Per_Over
ON Most_Runs.Player = Most_Runs_Per_Over.Player
WHERE Most_Runs_Per_Over.Runs >= '35'
ORDER BY Per_Over_Runs DESC;
(23). List Out Player who hit maximum Sixes since 13-05-2014 to 28-05-2014 ?
SELECT Player
, Runs
, BF
, SR
, Fours
, Sixes
, Against
, Venue
, Match_Date
FROM Most_Sixes_Per_Inn
WHERE Match_Date >= '2014-05-13' AND Match_Date <= '2014-05-28'
ORDER BY Sixes DESC
LIMIT 5;
(24). Player Who Hit's Maximum Sixes in a single Inning Since 2021. ?
SELECT Player
, Runs
, BF
, SR
, Fours
, Sixes
, Against
, Venue
, Match_Date
FROM Most_Sixes_Per_Inn
WHERE Match_Date >= '2021-05-01' AND Match_Date <= '2021-10-02'
ORDER BY Sixes DESC
LIMIT 1;
(25). List OUT Plauyer who Hit's Maximum Number of fours and sixes Against With Venue In 2016 ?
SELECT Most_Sixes_Per_Inn.Player
, Most_Four_Per_Inning.Fours
, Most_Sixes_Per_Inn.Sixes
, Most_Four_Per_Inning.Against
, Most_Sixes_Per_Inn.Venue
, Most_Four_Per_Inning.Match_Date
FROM Most_Sixes_Per_Inn
INNER JOIN Most_Four_Per_Inning
ON Most_Sixes_Per_Inn.Player = Most_Four_Per_Inning.Player
WHERE Most_Four_Per_Inning.Match_Date >= '2016-04-17' AND Most_Four_Per_Inning.Match_Date <= '2016-05-07'
ORDER BY Sixes DESC
LIMIT 5;
(26). Find Out A Player Who Make Fatest Centuries in 2021 With Their States ?
SELECT Player
, Runs
, BF
, Fours
, Sixes
, Against
, Venue
, Match_Date
FROM Fatest_Centuries
WHERE Match_Date >= '2021-05-01' AND Match_Date <= '2021-10-02'
ORDER BY Sixes DESC
LIMIT 1;
(27). Find Out A Player Who Hits Maximum Number of sixes in Single Inning's in IPL Season 2010 ?
SELECT Most_Runs.Player
, Most_Runs.Runs
, Fatest_Centuries.Fours
, Fatest_Centuries.Sixes
, Fatest_Centuries.Against
, Fatest_Centuries.Match_Date
FROM Fatest_Centuries
JOIN Most_Runs
ON Fatest_Centuries.Player = Most_Runs.Player
WHERE Match_Date >= '2010-04-03' AND Match_Date <= '2010-04-09'
ORDER BY Sixes DESC
LIMIT 1;
(28). List Out Over_All States That How Many Times Chennai Super Kings Play Final Since 2008 TO 2023 in IPL ?
SELECT *
FROM Ipl_Data
WHERE Match_Type = 'Final' AND (Team1 = 'Chennai Super Kings' OR Team2 = 'Chennai Super Kings')
ORDER BY Season ASC;
(29). List Out Over_All That How Many Times Royal Challengers Bangalore Play Final Since 2008 TO 2023 in IPL ?
SELECT Season
, City
, Date
, Match_Type
, Player_Of_Match
, Team1
, Team2
, Winner
FROM Ipl_Data
WHERE Match_Type = 'Final' AND (Team1 = 'Royal Challengers Bangalore' OR Team2 = 'Royal Challengers Bangalore')
ORDER BY Season ASC;
(30). Total Number of Time's Mumbai Indians Won Against Chennai Super Kings ?
SELECT Season
, City
, Date
, Match_Type
, Player_Of_Match
, Team1
, Team2
, Winner
, Result
, Result_Margin
FROM Ipl_Data
WHERE Winner = 'Mumbai Indians' AND (Team1 = 'Chennai Super Kings' OR Team2 = 'Chennai Super Kings')
ORDER BY Season ASC;
(31). How Many Times Player of The Match Awards Goes to MS Dhoni While Chennai Super Kings Win The Match IPL ?
SELECT COUNT(*)
FROM Ipl_Data
WHERE Player_Of_Match = 'MS Dhoni' AND Winner = 'Chennai Super Kings'
(32). As Player Of The Match Awards Goes to V Kohli Against KKR OR KXIP in IPL Since2008 TO 2023 ?
SELECT Season
, City
, Date
, Match_Type
, Player_Of_Match
, Team1
, Team2
, Winner
, Result
, Result_Margin
FROM Ipl_Data
WHERE Player_Of_Match = 'V Kohli' AND (Team1 = 'Kolkata Knight Riders' OR Team2 = 'Kings XI Punjab')
(33). How Many Total_Match_Played in IPL At Venue M Chinnaswamy Stadium Since 2008 to 2023 ?
SELECT COUNT(*) Total_Match_Played
FROM Ipl_Data
WHERE Venue = 'M Chinnaswamy Stadium';
(34). Count Total Number of Super Over Played in IPL Since 2008 TO 2023 ?
SELECT COUNT(*) Total_Super_Over_Match
FROM Ipl_Data
WHERE Super_Over = 'Y';
(35). Match Played in Bharat Ratna Shri Atal Bihari Vajpayee Ekana Cricket Stadium, Lucknow And Score More Than & Equal to 150 in IPL ?
SELECT Team1
, Team2
, Winner
, Player_Of_Match
, Target_Runs
, Season
, Date
, Match_Type
, Venue
FROM Ipl_Data
WHERE Venue = 'Bharat Ratna Shri Atal Bihari Vajpayee Ekana Cricket Stadium, Lucknow' AND Target_Runs >= '150'
ORDER BY Target_Runs DESC;
(36). Umpire HDPK Dharmasena Umpiring in the IPL Final Since 2008 To 2024 ?
SELECT Team1
, Team2
, Winner
, Player_Of_Match
, Target_Runs
, Season
, Date
, Match_Type
, Venue
, Umpire1
, Umpire2
FROM IPL_Data
WHERE Match_Type = 'Final' AND (Umpire1 = 'HDPK Dharmasena' OR Umpire2 = 'HDPK Dharmasena');
(37). Total_Upiring_Inning By HDPK Dharmasena In IPL Since 2008 To 2024 ?
SELECT COUNT(*) Total_Upiring_Inning
FROM IPL_Data
WHERE Umpire1 = 'HDPK Dharmasena' OR Umpire2 = 'HDPK Dharmasena';
(38). With Specific Condition with the Match type is final and Team is Rajasthan Royals With Toss Winner and Also Match Winner ?
SELECT Team1
, Team2
, Match_Type
, Toss_Winner
, Toss_Decision
, Winner
, Date
, Venue
FROM IPL_Data
WHERE Toss_Winner = 'Rajasthan Royals' AND (Match_Type = 'Final' AND Winner = 'Rajasthan Royals');
