Swiggy Data Analyst SQL Interview Question and Answer

Published: 03 May 2024
on channel: Ankit Bansal

18,282

571

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 Adva...

Most Asked Join Based Interview Question:
   • Most Asked SQL JOIN based Interview Q...

Solving 4 Trick SQL problems:
   • Solving 4 Tricky SQL Problems

Data Analyst Spotify Case Study:
   • Data Analyst Spotify Case Study | SQL...

Top 10 SQL interview Questions:
   • Top 10 SQL interview Questions and An...

Interview Question based on FULL OUTER JOIN:
   • SQL Interview Question Based on Full ...

Playlist to master SQL :
   • Complex SQL Questions for Interview P...

Rank, Dense_Rank and Row_Number:
   • RANK, DENSE_RANK, ROW_NUMBER SQL Anal...

#sql #dataanalyst #datanalytics

On this page of the site you can watch the video online Swiggy Data Analyst SQL Interview Question and Answer with a duration of hours minute second in good quality, which was uploaded by the user Ankit Bansal 03 May 2024, share the link with friends and acquaintances, this video has already been watched 18,282 times on youtube and it was liked by 571 viewers. Enjoy your viewing!

139