Case 15 : Complex SQL Query 1 | Derive Points table for ICC tournament
#sql #sqlserver #sqltips #sqlforbeginners #sqlinterviewquestions
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;
Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the channel.
If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at [email protected], Please note it will be charged.
Thank you :)
✨ Work-related E- emails can be sent to: [email protected]