Swiggy Data Analyst SQL Interview Question and Answer

In this video we will discuss a sql interview question asked in Swiggy for a Data Analyst Position. Here is the script: -- Create the table CREATE TABLE stock ( supplier_id INT, product_id INT, stock_quantity INT, record_date DATE ); -- Insert the data delete from stock; INSERT INTO stock (supplier_id, product_id, stock_quantity, record_date) VALUES (1, 1, 60, '2022-01-01'), (1, 1, 40, '2022-01-02'), (1, 1, 35, '2022-01-03'), (1, 1, 45, '2022-01-04'), (1, 1, 51, '2022-01-06'), (1, 1, 55, '2022-01-09'), (1, 1, 25, '2022-01-10'), (1, 1, 48, '2022-01-11'), (1, 1, 45, '2022-01-15'), (1, 1, 38, '2022-01-16'), (1, 2, 45, '2022-01-08'), (1, 2, 40, '2022-01-09'), (2, 1, 45, '2022-01-06'), (2, 1, 55, '2022-01-07'), (2, 2, 45, '2022-01-08'), (2, 2, 48, '2022-01-09'), (2, 2, 35, '2022-01-10'), (2, 2, 52, '2022-01-15'), (2, 2, 23, '2022-01-16'); Zero to hero(Advance) SQL Aggregation:    • All About SQL Aggregations | SQL Advance |...   Most Asked Join Based Interview Question:    • Most Asked SQL JOIN based Interview Questi...   Solving 4 Trick SQL problems:    • Solving 4 Tricky SQL Problems   Data Analyst Spotify Case Study:    • Data Analyst Spotify Case Study | SQL Inte...   Top 10 SQL interview Questions:    • Top 10 SQL interview Questions and Answers...   Interview Question based on FULL OUTER JOIN:    • SQL Interview Question Based on Full Outer...   Playlist to master SQL :    • Complex SQL Questions for Interview Prepar...   Rank, Dense_Rank and Row_Number:    • RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...   #sql #dataanalyst #datanalytics