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 are going to discuss on SQL interview problem asked in Amazon interview for Business Analyst position. This question will be solved using double SQL self join concept. 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, emp_name varchar(20), department_id int, salary int, manager_id int, emp_age int); insert into emp values (1, 'Ankit', 100,10000, 4, 39; insert into emp values (2, 'Mohit', 100, 15000, 5, 48); insert into emp values (3, 'Vikas', 100, 12000,4,37); insert into emp values (4, 'Rohit', 100, 14000, 2, 16); insert into emp values (5, 'Mudit', 200, 20000, 6,55); insert into emp values (6, 'Agam', 200, 12000,2, 14); insert into emp values (7, 'Sanjay', 200, 9000, 2,13); insert into emp values (8, 'Ashish', 200,5000,2,12); insert into emp values (9, 'Mukesh',300,6000,6,51); insert into emp values (10, 'Rakesh',500,7000,6,50); #sql #dataengineer #amazon