Zepto Business Analyst Interview- SQL Query

A question very similar to this was asked, in one of the rounds of interviews at Zepto.
Zepto Business Analyst Interview- SQL Query
#data analyst #data science #sql
Table Creation Code(DDL):
/*
CREATE TABLE Sessions ( Cust_ID INT, Timestamp timestamp, Searched_for VARCHAR(50) );
INSERT INTO Sessions (Cust_ID, Timestamp, Searched_for) VALUES
(1, '2024-08-01 08:00:00', 'Item A'),
(2, '2024-08-01 09:00:00', 'Item B'),
(1, '2024-08-01 08:20:00', 'Item A'),
(2, '2024-08-01 11:00:00', 'Item A'),
(1, '2024-08-01 10:00:00', 'Item B'),
(2, '2024-08-01 11:55:00', 'Item A'),
(1, '2024-08-01 10:40:00', 'Item A'),
(2, '2024-08-01 15:00:00', 'Item A'),
(1, '2024-08-01 16:00:00', 'Item B'),
(2, '2024-08-01 15:05:00', 'Item B'),
(1, '2024-08-01 18:00:00', 'Item A'),
(2, '2024-08-01 19:00:00', 'Item B'),
(1, '2024-08-01 20:00:00', 'Item A'),
(2, '2024-08-01 21:00:00', 'Item B'),
(1, '2024-08-01 20:35:00', 'Item A');
*/