Zomato Senior Business Analyst Interview- SQL Query

Zomato SQL Interview Question: A question very similar to this was asked, in one of the rounds of interviews at Zomato (Tech Rounds - SQL Round). Zomato Business Analyst Interview- Learn sql by attempting this SQL Query #data analyst #data science #sql Table Creation Code(DDL): /* CREATE TABLE orders ( timestamp TIMESTAMPTZ NOT NULL, city VARCHAR(50) NOT NULL, order_id SERIAL PRIMARY KEY, customer_id INT NOT NULL, order_total NUMERIC(10, 2) NOT NULL ); INSERT INTO orders (timestamp, city, customer_id, order_total) VALUES ('2024-01-15 08:15:00+00', 'Mumbai', 1001, 1200.50), ('2024-01-28 09:45:00+00', 'Delhi', 1002, 950.00), ('2024-02-10 11:30:00+00', 'Bengaluru', 1003, 675.75), ('2024-02-22 13:00:00+00', 'Hyderabad', 1004, 1500.20), ('2024-03-05 15:15:00+00', 'Chennai', 1005, 800.00), ('2024-03-17 10:45:00+00', 'Kolkata', 1006, 1200.50), ('2024-04-02 09:30:00+00', 'Pune', 1007, 1300.75), ('2024-04-14 12:15:00+00', 'Ahmedabad', 1008, 1100.25), ('2024-05-06 14:45:00+00', 'Surat', 1009, 1400.00), ('2024-05-19 11:00:00+00', 'Jaipur', 1010, 600.30), ('2024-06-03 08:45:00+00', 'Mumbai', 1001, 1300.00), ('2024-06-25 10:15:00+00', 'Delhi', 1002, 750.50), ('2024-07-08 09:00:00+00', 'Bengaluru', 1003, 1350.75), ('2024-07-20 13:45:00+00', 'Hyderabad', 1004, 900.00), ('2024-08-02 15:30:00+00', 'Chennai', 1005, 1650.25), ('2024-08-15 11:15:00+00', 'Kolkata', 1006, 950.00), ('2024-09-05 14:00:00+00', 'Pune', 1007, 850.75), ('2024-09-18 16:15:00+00', 'Ahmedabad', 1008, 1250.20), ('2024-10-07 12:30:00+00', 'Surat', 1009, 1050.00), ('2024-10-20 10:45:00+00', 'Jaipur', 1010, 1600.50), ('2024-11-01 09:15:00+00', 'Mumbai', 1001, 1150.00), ('2024-11-12 14:30:00+00', 'Delhi', 1002, 800.75), ('2024-12-03 13:00:00+00', 'Bengaluru', 1003, 1300.00), ('2024-12-15 15:45:00+00', 'Hyderabad', 1004, 1450.50), ('2024-01-10 10:15:00+00', 'Chennai', 1005, 1100.00), ('2024-02-25 09:45:00+00', 'Kolkata', 1006, 950.75), ('2024-03-18 13:30:00+00', 'Pune', 1007, 1550.00), ('2024-04-21 11:45:00+00', 'Ahmedabad', 1008, 1050.20), ('2024-05-09 14:00:00+00', 'Surat', 1009, 1200.50), ('2024-06-30 16:15:00+00', 'Jaipur', 1010, 1350.75); */