Рет қаралды 79
Namastey All,
Welcome to Select Star. Today I am doing a simple case study related to cricket. We will find out if taking more catches helps ypu win a match.
Topics covered from SQL :
1. Self Join
2. Right Join
3. COUNT
4. CASE WHEN
5. GROUP BY
Related Playlists:
1. Basic SQL Course :
• Basic SQL Course
2. SQL Easy Interview Questions :
• SQL Easy Interview Que...
3. SQL Mediun to Hard Level Interview Questions :
• SQL Intermediate to Ad...
If you want me to solve some specific questions, then email me :
ananttnegii@gmail.com
Script for table creation :
create table deliveries (
match_id int,inning int,batting_team varchar(100),
bowling_team varchar(100),over int,ball int,
batter varchar(100),bowler varchar(100),non_striker varchar(100),
batsman_runs int,extra_runs int,total_runs int,
extras_type varchar(100),is_wicket boolean,player_dismissed varchar(100),
dismissal_kind varchar(100),fielder varchar(100))
select * from deliveries;
create table matches (
id int,season varchar(100),city varchar(100),
date date,match_type varchar(100),player_of_match varchar(100),
venue varchar(100),team1 varchar(100),team2 varchar(100),
toss_winner varchar(100),toss_decision varchar(10),winner varchar(100),
result varchar(100),result_margin varchar(100),target_runs varchar(100),
target_overs varchar(100),super_over varchar(100),method varchar(100),
umpire1 varchar(100),umpire2 varchar(100))
select * from matches;
Data Download : www.kaggle.com...
Happy Querying
#sql #data #dataanalytics #dataanalyst #analysis #analyst #dataengineers #dataengineering #machinelearning #datascience #datascientist #machinelearningengineer #businessanalyst #businessanalyticsjobs #businessanalytics #sqlserver #sqltips #sqlforbeginners #postgres #postgresql #mssqlserver #mssql #oracle #mysql #mysqltutorials #database #databasedesign #databasemanagement