Скачать или смотреть ICC World Cup SQL Interview Question | Build Points Table in SQL

Tableau, Tableau Tutorial, SQL, Data Analytics, Snowflake, Dashboard Design, Ankush Sharma
Learn how to solve an ICC World Cup cricket points table challenge using SQL! This tutorial covers calculating points based on wins and losses, perfect for SQL interview practice. Follow along to build and sort the points table step-by-step.
___________________________________________________________________________
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');