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 I will be solving a SQL problem with 3 different methods. 00:00 Understand the Problem 01:21 Method 1 : Lead/Lag 06:24 Method 2 : Advance Aggregation 10:55 Method 3: Using ROW_NUMBER Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Data Analyst Interview 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 bms (seat_no int ,is_empty varchar(10)); insert into bms values (1,'N') ,(2,'Y') ,(3,'N') ,(4,'Y') ,(5,'Y') ,(6,'Y') ,(7,'N') ,(8,'Y') ,(9,'Y') ,(10,'Y') ,(11,'Y') ,(12,'N') ,(13,'Y') ,(14,'Y'); #sql #advance #dataengineer