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 will discuss 4 SQL problems and their solutions. 00:00 Understand the data 01:00 Problem 1 Fairly easy 03:58 Problem 2 Interesting one 07:15 Problem 3 Tricky one 13:12 Problem 4 Typical lead/lag Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Data Analyst Spotify Case Study: https://youtu.be/-YdAIMjHZrM Top 10 SQL interview Questions: https://youtu.be/Iv9qBz-cyVA Interview Question based on FULL OUTER JOIN: https://youtu.be/KQfWd6V3IB8 Playlist to master SQL : https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Rank, Dense_Rank and Row_Number: https://youtu.be/xMWEVFC4FOk script: CREATE TABLE [students]( [studentid] [int] NULL, [studentname] [nvarchar](255) NULL, [subject] [nvarchar](255) NULL, [marks] [int] NULL, [testid] [int] NULL, [testdate] [date] NULL ) data: insert into students values (2,'Max Ruin','Subject1',63,1,'2022-01-02'); insert into students values (3,'Arnold','Subject1',95,1,'2022-01-02'); insert into students values (4,'Krish Star','Subject1',61,1,'2022-01-02'); insert into students values (5,'John Mike','Subject1',91,1,'2022-01-02'); insert into students values (4,'Krish Star','Subject2',71,1,'2022-01-02'); insert into students values (3,'Arnold','Subject2',32,1,'2022-01-02'); insert into students values (5,'John Mike','Subject2',61,2,'2022-11-02'); insert into students values (1,'John Deo','Subject2',60,1,'2022-01-02'); insert into students values (2,'Max Ruin','Subject2',84,1,'2022-01-02'); insert into students values (2,'Max Ruin','Subject3',29,3,'2022-01-03'); insert into students values (5,'John Mike','Subject3',98,2,'2022-11-02'); #sql #dataengineer