IPL generate Points table using SQL | Scenario based questions

DML Script:

DROP TABLE IF EXISTS IPLResults

CREATE TABLE IPLResults

(

[MatchN] INT,

[TeamA] varchar(100),

[TeamB] varchar(100),

[WinningTeam] varchar(100)

)

INSERT INTO IPLResults

VALUES

(1, 'Chennai Super Kings' ,'Royal Challengers Bangalore' ,'Chennai Super Kings'),

(2, 'Delhi Capitals' ,'Punjab Kings' ,'Punjab Kings'),

(3, 'Kolkata Knight Riders' ,'Sunrisers Hyderabad' ,'Kolkata Knight Riders'),

(4, 'Rajasthan Royals' ,'Lucknow Super Giants' ,'Rajasthan Royals'),

(5, 'Gujarat Titans' ,'Mumbai Indians' ,'Gujarat Titans'),

(6, 'Punjab Kings' ,'Royal Challengers Bangalore' ,'Royal Challengers Bangalore'),

(7, 'Chennai Super Kings' ,'Gujarat Titans' ,'Chennai Super Kings'),

(8, 'Sunrisers Hyderabad' ,'Mumbai Indians' ,'Sunrisers Hyderabad'),

(9, 'Rajasthan Royals' ,'Delhi Capitals' ,'Rajasthan Royals'),

(10, 'Royal Challengers Bangalore' ,'Kolkata Knight Riders' ,'Kolkata Knight Riders'),

(11, 'Lucknow Super Giants' ,'Punjab Kings' ,'Lucknow Super Giants'),

(12, 'Sunrisers Hyderabad' ,'Gujarat Titans' ,'Gujarat Titans'),

(13, 'Delhi Capitals' ,'Chennai Super Kings' ,'Delhi Capitals'),

(14, 'Gujarat Titans', 'Kolkata Knight Riders','NA')

select * from IPLResults

order by MatchN

SQL