Write Complex SQL Queries 2 | Cricket Analytics | Interview questions with Solution |
▶ Evaluate yourself if you can become a successful Business Analyst
https://topmate.io/analyticalguy/132311
▶ In SQL Wednesdays, I will cover 1 problem that has been asked in FAANG Interviews. So, watch these videos to improve your chances to crack the interviews.
SQL query for Creating the table and inserting the records.
Create table cricket_tournament
(Home_Team varchar(255),
Away_Team varchar(255),
Winner varchar(255)
)
insert into cricket_tournament values ('India','Australia','India')
insert into cricket_tournament values ('Sri Lanka','West Indies','West Indies')
insert into cricket_tournament values ('Australia','New Zealand','Australia')
insert into cricket_tournament values ('Pakistan','England','England')
insert into cricket_tournament values ('South Africa','India','India')
💡 SQL TUTORIAL FOR BEGINNERS
========================
SQL Series: • SQL Series
SQL Introduction (Part1): • SQL Tutorial for Beginners | Complete Guid...
SQL Beginner Level 17 Questions (Part2): • Top 17 SQL Queries with Answers for INTERV...
SQL Intermediate Level 24 Questions (Part3): • 24 SQL Query Interview Questions and Answe...
SQL Hard Level 10 Questions (Part4): • TOP 10 SQL Query Interview Questions and A...
SQL Wednesdays: • SQL Wednesdays