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 challenging SQL interview question asked in Amazon for data engineer position. Practice more high quality SQL and Py-Spark Interview questions here : https://www.namastesql.com/coding-problems script: CREATE TABLE input_table_1 ( Market VARCHAR(50), Sales INT ); INSERT INTO input_table_1 (Market, Sales) VALUES ('India', 100), ('Maharashtra', 20), ('Telangana', 18), ('Karnataka', 22), ('Gujarat', 25), ('Delhi', 12), ('Nagpur', 8), ('Mumbai', 10), ('Agra', 5), ('Hyderabad', 9), ('Bengaluru', 12), ('Hubli', 12), ('Bhopal', 5); CREATE TABLE input_table_2 ( Country VARCHAR(50), State VARCHAR(50), City VARCHAR(50) ); delete from input_table_2; INSERT INTO input_table_2 (Country, State, City) VALUES ('India', 'Maharashtra', 'Nagpur'), ('India', 'Maharashtra', 'Mumbai'), ('India', 'Maharashtra', 'Akola'), ('India', 'Telangana', 'Hyderabad'), ('India', 'Karnataka', 'Bengaluru'), ('India', 'Karnataka', 'Hubli'), ('India', 'Gujarat', 'Ahmedabad'), ('India', 'Gujarat', 'Vadodara'), ('India', 'UP', 'Agra'), ('India', 'UP', 'Mirzapur'), ('India', 'Delhi', NULL), ('India', 'Orissa', NULL); 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