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 a tricky SQL question where we need to perform horizontal sorting. 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 subscriber ( sms_date date , sender varchar(20) , receiver varchar(20) , sms_no int ); -- insert some values INSERT INTO subscriber VALUES ('2020-4-1', 'Avinash', 'Vibhor',10); INSERT INTO subscriber VALUES ('2020-4-1', 'Vibhor', 'Avinash',20); INSERT INTO subscriber VALUES ('2020-4-1', 'Avinash', 'Pawan',30); INSERT INTO subscriber VALUES ('2020-4-1', 'Pawan', 'Avinash',20); INSERT INTO subscriber VALUES ('2020-4-1', 'Vibhor', 'Pawan',5); INSERT INTO subscriber VALUES ('2020-4-1', 'Pawan', 'Vibhor',8); INSERT INTO subscriber VALUES ('2020-4-1', 'Vibhor', 'Deepak',50); #sql #amazon #BIE