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 solve a Amazon SQL interview question on notepad. This will help all the job aspirants to understand how to solve on notepad. script: CREATE TABLE subscription_history ( customer_id INT, marketplace VARCHAR(10), event_date DATE, event CHAR(1), subscription_period INT ); INSERT INTO subscription_history VALUES (1, 'India', '2020-01-05', 'S', 6); INSERT INTO subscription_history VALUES (1, 'India', '2020-12-05', 'R', 1); INSERT INTO subscription_history VALUES (1, 'India', '2021-02-05', 'C', null); INSERT INTO subscription_history VALUES (2, 'India', '2020-02-15', 'S', 12); INSERT INTO subscription_history VALUES (2, 'India', '2020-11-20', 'C', null); INSERT INTO subscription_history VALUES (3, 'USA', '2019-12-01', 'S', 12); INSERT INTO subscription_history VALUES (3, 'USA', '2020-12-01', 'R', 12); INSERT INTO subscription_history VALUES (4, 'USA', '2020-01-10', 'S', 6); INSERT INTO subscription_history VALUES (4, 'USA', '2020-09-10', 'R', 3); INSERT INTO subscription_history VALUES (4, 'USA', '2020-12-25', 'C', null); INSERT INTO subscription_history VALUES (5, 'UK', '2020-06-20', 'S', 12); INSERT INTO subscription_history VALUES (5, 'UK', '2020-11-20', 'C', null); INSERT INTO subscription_history VALUES (6, 'UK', '2020-07-05', 'S', 6); INSERT INTO subscription_history VALUES (6, 'UK', '2021-03-05', 'R', 6); INSERT INTO subscription_history VALUES (7, 'Canada', '2020-08-15', 'S', 12); INSERT INTO subscription_history VALUES (8, 'Canada', '2020-09-10', 'S', 12); INSERT INTO subscription_history VALUES (8, 'Canada', '2020-12-10', 'C', null); INSERT INTO subscription_history VALUES (9, 'Canada', '2020-11-10', 'S', 1); 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 #sql #dataengineer