SQL

 DROP TABLE IF EXISTS [Event]; CREATE TABLE [Event] (     session_id INT,     event_type VARCHAR(50),     event_time DATETIME );  Dataset 1:  -- Insert expanded event data INSERT INTO [Event] (session_id, event_type, event_time) VALUES (1, 'login', '2024-10-01 08:00:00'), (1, 'view', '2024-10-01 08:05:00'), (1, 'purchase', '2024-10-01 08:10:00'), (2, 'login', '2024-10-01 09:00:00'), (2, 'add_to_cart', '2024-10-01 09:05:00'), (2, 'purchase', '2024-10-01 09:10:00'), (3, 'login', '2024-10-01 10:00:00'), (3, 'view', '2024-10-01 10:05:00'), (3, 'purchase', '2024-10-01 10:10:00'), (4, 'login', '2024-10-01 10:30:00'), (4, 'search', '2024-10-01 10:35:00'), (4, 'view', '2024-10-01 10:40:00'), (4, 'add_to_cart', '2024-10-01 10:45:00'), (4, 'purchase', '2024-10-01 10:50:00'), ...

- DROP TABLE IF EXISTS [Event]; CREATE TABLE [Event] (     session_id INT,     event_type VARCHAR(50),     event_time DATETIME ); -- Dataset 3: Customers frequently search for items before viewing or adding to cart INSERT INTO Events (session_id, event_type, event_time) VALUES (1, 'login', '2024-10-03 08:00:00'), (1, 'search', '2024-10-03 08:05:00'), (1, 'view', '2024-10-03 08:10:00'), (1, 'add_to_cart', '2024-10-03 08:15:00'), (1, 'purchase', '2024-10-03 08:20:00'), (2, 'login', '2024-10-03 09:00:00'), (2, 'search', '2024-10-03 09:05:00'), (2, 'view', '2024-10-03 09:10:00'), (2, 'purchase', '2024-10-03 09:15:00'), (3, 'login', '2024-10-03 10:00:00'), (3, 'search', '2024-10-03 10:05:00'), (3, 'view', '2024-10-03 10:10:00'), (3, 'add_to_cart', '2024-10-03 10:15:00'), (3, 'purcha...

- DROP TABLE IF EXISTS [Event]; CREATE TABLE [Event] (     session_id INT,     event_type VARCHAR(50),     event_time DATETIME ); -- Dataset 2  INSERT INTO Events (session_id, event_type, event_time) VALUES (1, 'login', '2024-10-05 08:00:00'), (1, 'view', '2024-10-05 08:05:00'), (1, 'view', '2024-10-05 08:10:00'), (1, 'add_to_cart', '2024-10-05 08:15:00'), (2, 'login', '2024-10-05 09:00:00'), (2, 'view', '2024-10-05 09:05:00'), (2, 'view', '2024-10-05 09:10:00'), (2, 'add_to_cart', '2024-10-05 09:15:00'), (2, 'purchase', '2024-10-05 09:20:00'), (3, 'login', '2024-10-05 10:00:00'), (3, 'view', '2024-10-05 10:05:00'), (3, 'view', '2024-10-05 10:10:00'), (3, 'add_to_cart', '2024-10-05 10:15:00');  

 DROP TABLE IF EXISTS Employees; CREATE TABLE Employees (     id INT PRIMARY KEY,     name VARCHAR(50),     joiningdate DATE ); INSERT INTO Employees (id, name, joiningdate) VALUES (1, 'Bob', '2020-03-22'), (2, 'Alice', '2021-01-15'), (3, 'Charlie', '2019-11-30'), (4, 'David', '2022-07-19'), (5, 'Eve', '2023-02-01'), (6,'Chris', '2023-02-02'); SELECT * FROM Employees

 DROP TABLE IF EXISTS Employee; CREATE TABLE Employee (     EmpID INT PRIMARY KEY,     Name VARCHAR(100),     Department VARCHAR(50),     Salary DECIMAL(10, 2),     HireDate DATE,     YearsInCompany INT ); INSERT INTO Employee (EmpID, Name, Department, Salary, HireDate, YearsInCompany) VALUES (1, 'Alice', 'IT', 70000, '2015-05-10', 9), (2, 'Bob', 'HR', 50000, '2020-02-15', 4), (3, 'Charlie', 'IT', 65000, '2017-07-22', 7), (4, 'David', 'Sales', 55000, '2019-09-30', 5), (5, 'Eva', 'HR', 72000, '2016-03-12', 8), (6, 'Frank', 'Finance', 80000, '2014-01-05', 10), (7, 'Grace', 'IT', 67000, '2018-11-19', 6), (8, 'Henry', 'Sales', 59000, '2021-05-08', 3), (9, 'Irene', 'HR', 75000, '2016-12-10', 8), (10, 'Jack', 'IT', 78000, '2013-06-25', 11), (11, 'Kate...

Rules 1. Sec 80C - 150000 or the value which ever is lower 2. Sec 80D - 25000 or the value which ever is lower 3. Sec 80G - The value in the table 4. Standard Deduction - 50000 Income Range Tax Rate Up to ₹2,50,000 Nil ₹2,50,001 – ₹5,00,000 5% ₹5,00,001 – ₹10,00,000 20% Above ₹10,00,000 30%  DROP TABLE IF EXISTS EmployeeTaxDetails; CREATE TABLE EmployeeTaxDetails (     emp_id INT PRIMARY KEY,     Sec80C INT,     Sec80D INT,     Sec80G INT,     Total_Salary INT ); -- Insert the 10 rows of data INSERT INTO EmployeeTaxDetails (emp_id, Sec80C, Sec80D, Sec80G, Total_Salary) VALUES (1, 100000.00, 20000.00, 5000.00, 250000.00), (2, 250000.00, 25000.00, 10000.00, 300000.00), (3, 80000.00, 40000.00, 15000.00, 350000.00), (4, 120000.00, 30000.00, 8000.00, 500000.00), (5, 170000.00, 35000.00, 12000.00, 650000.00), (6, 175000.00, 40000.00, 18000.00, 900000.00), (7, 100000.00, 45000.00, 25000.00, 1250000.00), (8, 150000.00, 50...

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