Amazon Data Engineer SQL Interview Question | Salesperson Without Orders (Explained)
In this video, Shilpa from Shilpa Data Insights walks through a real SQL interview question asked in Amazon for the Data Engineer role. ๐ Problem Statement: Find the names of all salespersons who did NOT have any orders related to a company named "RED". This question tests your understanding of SQL filtering logic and anti-joins, which are commonly asked in Amazon and other top MNC interviews. ๐ก Key SQL Concepts Covered: โข NOT IN vs NOT EXISTS โข LEFT JOIN with NULL filtering โข Subqueries โข Interview-ready SQL thinking โ Ideal for preparation for: โข Amazon Data Engineer interviews โข SQL interviews for product-based companies โข Data Analyst & Data Engineering roles ๐ Learn how Amazon expects you to approach SQL problems, not just write correct queries. ๐ Subscribe to Shilpa Data Insights for more real interview questions, SQL walkthroughs, and career guidance in data engineering. ๐ Mentorship & 1:1 Guidance If youโre looking to transition into Data Engineering or need interview mentorship, you can connect with me 1:1 on TopMate. https://topmate.io/shilpa_das10 ๐ ๐๐ผ๐ถ๐ป ๐๐ฟ๐ผ๐๐ฝ ๐๐ฒ๐ฟ๐ฒ ๐๐ผ ๐๐ฒ๐ ๐ฆ๐๐ฐ๐ต ๐ ๐ผ๐ฟ๐ฒ ๐ฅ๐ฒ๐๐ผ๐๐ฟ๐ฐ๐ฒ๐ : https://whatsapp.com/channel/0029Vb5j5Ku0VycHdViPPJ1Y Link to Spark playlist: https://www.youtube.com/playlist?list=PLHcpPiCf7ryZf8GAFKcFuYmOxswcCOGz4 Link to Databricks playlist: https://www.youtube.com/playlist?list=PLHcpPiCf7ryZLNLvSsglM05lJXaWngHUH Link to Databricks certification : https://www.youtube.com/playlist?list=PLHcpPiCf7ryZrusmfkgteZvSMO16hagP5 Link to Big data: https://www.youtube.com/playlist?list=PLHcpPiCf7ryYfIrrJBQDa0Vw9BXIY-mUD Link to Interview series for Pyspark: https://www.youtube.com/playlist?list=PLHcpPiCf7ryYp8KKn0sWfLugYEEsF2UOf #DataEngineering #sql #BigData #ShilpaDataInsights #DataEngineerInterview #InterviewQuestions
Download
1 formatsVideo Formats
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.