This playlist contains scenario based SQL problems. After solving these you should be able to ace any SQL interview. As and when I find a good problem, i will add it to this playlist.
Curated by: Ankit Bansal (96 videos)
In this video we are going to discuss about a very interesting SQL scenario where we will be deriving points table for a typical tournament . I am putting the create and insert script below. Please do try yourself first before checking the solution. create table icc_world_cup ( Team_1 Varchar(20), Team_2 Varchar(20), Winner Varchar(20) ); INSERT INTO icc_world_cup values('India','SL','India'); INSERT INTO icc_world_cup values('SL','Aus','Aus'); INSERT INTO icc_world_cup values('SA','Eng','Eng'); INSERT INTO icc_world_cup values('Eng','NZ','NZ'); INSERT INTO icc_world_cup values('Aus','India','India'); select * from icc_world_cup;