Flipkart user activity

 DROP TABLE IF EXISTS UserActivity ;


CREATE TABLE UserActivity (

    id INT,

    activity_time DATETIME,

    type VARCHAR(20)

);


INSERT INTO UserActivity (id, activity_time, type) VALUES

-- Day 1

(1, '2024-10-01 08:00:00', 'log in'),

(1, '2024-10-01 08:15:30', 'scroll'),

(1, '2024-10-01 08:30:00', 'log out'),

(1, '2024-10-01 12:00:00', 'log in'),

(1, '2024-10-01 12:10:30', 'scroll'),

(1, '2024-10-01 12:30:00', 'log out'),

(2, '2024-10-01 09:00:00', 'log in'),

(2, '2024-10-01 09:15:45', 'scroll'),

(2, '2024-10-01 09:45:00', 'log out'),

(2, '2024-10-01 14:30:00', 'log in'),

(2, '2024-10-01 14:50:00', 'scroll'),

(2, '2024-10-01 15:30:00', 'log out'),

(3, '2024-10-01 07:45:00', 'log in'),

(3, '2024-10-01 08:00:00', 'scroll'),

(3, '2024-10-01 08:30:00', 'log out'),

(3, '2024-10-01 11:15:00', 'log in'),

(3, '2024-10-01 11:25:00', 'scroll'),

(3, '2024-10-01 12:00:00', 'log out'),


-- Day 2

(1, '2024-10-02 09:00:00', 'log in'),

(1, '2024-10-02 09:20:00', 'scroll'),

(1, '2024-10-02 09:40:00', 'log out'),

(1, '2024-10-02 14:00:00', 'log in'),

(1, '2024-10-02 14:15:00', 'scroll'),

(1, '2024-10-02 14:45:00', 'log out'),

(2, '2024-10-02 08:30:00', 'log in'),

(2, '2024-10-02 08:50:00', 'scroll'),

(2, '2024-10-02 09:15:00', 'log out'),

(2, '2024-10-02 12:45:00', 'log in'),

(2, '2024-10-02 13:10:00', 'scroll'),

(2, '2024-10-02 14:30:00', 'log out'),

(3, '2024-10-02 07:30:00', 'log in'),

(3, '2024-10-02 07:50:00', 'scroll'),

(3, '2024-10-02 08:20:00', 'log out'),

(3, '2024-10-02 10:00:00', 'log in'),

(3, '2024-10-02 10:15:00', 'scroll'),

(3, '2024-10-02 10:45:00', 'log out');



SELECT * FROM UserActivity

ORDER BY 1,2

Comments

Post a Comment

Popular posts from this blog

How to find all the customers who placed orders on three consecutive days | SQL Scenario questions

  DML Script: DROP TABLE IF EXISTS Orders CREATE TABLE Orders ( customer_name VARCHAR(255), order_date DATETIME ); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-01'); INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-01'); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-02'); INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-02'); INSERT INTO Orders (customer_name, order_date) VALUES ('Charlie', '2024-04-03'); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-03'); INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-04'); INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-04'); INSERT INTO Orders (customer_name, order_date) VALUES ('Charlie', '2024-04-05'); INSER...
Read more

NTT DATA SQL INTERVIEW QUESTION | Solve 80/20 Pareto rule

 DROP TABLE IF EXISTS Products -- Create the table CREATE TABLE Products (     ProductID INT PRIMARY KEY,     Name VARCHAR(50),     Sales DECIMAL(10, 2) ); -- Insert data into the table INSERT INTO Products (ProductID, Name, Sales) VALUES (1, 'Laptop', 8000.00), (2, 'Smartphone', 7000.00), (3, 'Tablet', 1500.00), (4, 'Headphones', 800.00), (5, 'Smartwatch', 700.00), (6, 'Monitor', 500.00), (7, 'Keyboard', 300.00), (8, 'Mouse', 200.00), (9, 'Charger', 100.00), (10, 'USB Cable', 100.00);  SELECT * FROM Products
Read more

50 Essential SQL Questions to Land Your Dream Job

 CREATE TABLE worker (     first_name VARCHAR(50),     last_name VARCHAR(50),     department VARCHAR(50),     salary DECIMAL(10, 2),     joining_date DATE ); INSERT INTO worker (first_name, last_name, department, salary, joining_date) VALUES  ('John', 'Doe', 'HR', 55000, '2020-01-15'), ('Jane', 'Smith', 'Finance', 67000, '2019-03-22'), ('Robert', 'Johnson', 'IT', 72000, '2018-06-10'), ('Emily', 'Davis', 'Marketing', 59000, '2021-07-01'), ('Michael', 'Wilson', 'Sales', 63000, '2020-09-15'), ('Sarah', 'Brown', 'HR', 56000, '2022-02-19'), ('David', 'Miller', 'Finance', 68000, '2019-10-05'), ('Laura', 'Garcia', 'IT', 75000, '2020-11-22'), ('James', 'Martinez', 'Marketing', 60000, '2021-03-18'), ('Olivia...
Read more