➣ 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');
Comments