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 and SQL interview question asked by Microsoft for a data analyst or data engineer position. The problem name is possible flight routes. Here is the script: CREATE TABLE airports ( port_code VARCHAR(10) PRIMARY KEY, city_name VARCHAR(100) ); CREATE TABLE flights ( flight_id varchar (10), start_port VARCHAR(10), end_port VARCHAR(10), start_time datetime, end_time datetime ); delete from airports; INSERT INTO airports (port_code, city_name) VALUES ('JFK', 'New York'), ('LGA', 'New York'), ('EWR', 'New York'), ('LAX', 'Los Angeles'), ('ORD', 'Chicago'), ('SFO', 'San Francisco'), ('HND', 'Tokyo'), ('NRT', 'Tokyo'), ('KIX', 'Osaka'); delete from flights; INSERT INTO flights VALUES (1, 'JFK', 'HND', '2025-06-15 06:00', '2025-06-15 18:00'), (2, 'JFK', 'LAX', '2025-06-15 07:00', '2025-06-15 10:00'), (3, 'LAX', 'NRT', '2025-06-15 10:00', '2025-06-15 22:00'), (4, 'JFK', 'LAX', '2025-06-15 08:00', '2025-06-15 11:00'), (5, 'LAX', 'KIX', '2025-06-15 11:30', '2025-06-15 22:00'), (6, 'LGA', 'ORD', '2025-06-15 09:00', '2025-06-15 12:00'), (7, 'ORD', 'HND', '2025-06-15 11:30', '2025-06-15 23:30'), (8, 'EWR', 'SFO', '2025-06-15 09:00', '2025-06-15 12:00'), (9, 'LAX', 'HND', '2025-06-15 13:00', '2025-06-15 23:00'), (10, 'KIX', 'NRT', '2025-06-15 08:00', '2025-06-15 10:00'); 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 #dataanalytics #microsoft