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 an SQL question to find 3rd highest salary employee in each department but there is a twist in the question. Check out the video for details. Zero to hero(Advance) SQL Aggregation: https://youtu.be/5Ighj_2PGV0 Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Solving 4 Trick SQL problems: https://youtu.be/Ck1gQrlS5pQ 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 [emp]( [emp_id] [int] NULL, [emp_name] [varchar](50) NULL, [salary] [int] NULL, [manager_id] [int] NULL, [emp_age] [int] NULL, [dep_id] [int] NULL, [dep_name] [varchar](20) NULL, [gender] [varchar](10) NULL ) ; insert into emp values(1,'Ankit',14300,4,39,100,'Analytics','Female') insert into emp values(2,'Mohit',14000,5,48,200,'IT','Male') insert into emp values(3,'Vikas',12100,4,37,100,'Analytics','Female') insert into emp values(4,'Rohit',7260,2,16,100,'Analytics','Female') insert into emp values(5,'Mudit',15000,6,55,200,'IT','Male') insert into emp values(6,'Agam',15600,2,14,200,'IT','Male') insert into emp values(7,'Sanjay',12000,2,13,200,'IT','Male') insert into emp values(8,'Ashish',7200,2,12,200,'IT','Male') insert into emp values(9,'Mukesh',7000,6,51,300,'HR','Male') insert into emp values(10,'Rakesh',8000,6,50,300,'HR','Male') insert into emp values(11,'Akhil',4000,1,31,500,'Ops','Male') #sql #dataengineer #interview