In this video, we will solve the SQL Medium Level interview question asked in Zomato.
SQL Script:
CREATE TABLE SalesData (
sales_date DATE,
sales_amount INT
);
INSERT INTO SalesData (sales_date, sales_amount)
VALUES
('2024-08-01', 100),
('2024-08-02', 150),
('2024-08-03', 200),
('2024-08-04', 180), -- (Reset)
('2024-08-05', 220),
('2024-08-06', 250),
('2024-08-07', 230), -- (Reset)
('2024-08-08', 300),
('2024-08-09', 350);
Easy - Level questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPIRr92ZlRnw6H__IgWQdetg&si=-HgJ2ZeVg1IL35f3
Medium - Level questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPI6zpFi9-BENOuzCtUpMUwe&si=O1m4aK2fupBozHNt
Hard-Level SQL interview questions -
https://youtube.com/playlist?list=PLP8zk3fCtbPK-D8N_jInxlPNaDdlwEjHJ&si=gHH5avPPSunyM6Jx
If you have any interesting SQL questions, feel free to send them to me at
kulkarnisneha891@gmail.com.
#sqlserver #dataanalytics #dataanalyst
#sqlqueries
#dataanalytics
#dataengineering #datascientist #datascience
#problemsolving #data #sqlinterviewquestionsandanswers
#zomato