Acies Global SQL Interview Question | Employee Swipe in and Swipe out
In this video we will solve a tricky SQL interview question asked in Acies Global interview.
You can now practice high quality SQL questions on Namaste SQL : https://www.namastesql.com/coding-pro...
Script:
CREATE TABLE swipe (
employee_id INT,
activity_type VARCHAR(10),
activity_time datetime
);
-- Insert sample data
INSERT INTO swipe (employee_id, activity_type, activity_time) VALUES
(1, 'login', '2024-07-23 08:00:00'),
(1, 'logout', '2024-07-23 12:00:00'),
(1, 'login', '2024-07-23 13:00:00'),
(1, 'logout', '2024-07-23 17:00:00'),
(2, 'login', '2024-07-23 09:00:00'),
(2, 'logout', '2024-07-23 11:00:00'),
(2, 'login', '2024-07-23 12:00:00'),
(2, 'logout', '2024-07-23 15:00:00'),
(1, 'login', '2024-07-24 08:30:00'),
(1, 'logout', '2024-07-24 12:30:00'),
(2, 'login', '2024-07-24 09:30:00'),
(2, 'logout', '2024-07-24 10:30:00');
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregations | SQL Adva...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN based Interview Q...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL Problems
Data Analyst Spotify Case Study:
• Data Analyst Spotify Case Study | SQL...
Top 10 SQL interview Questions:
• Top 10 SQL interview Questions and An...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question Based on Full ...
Playlist to master SQL :
• Complex SQL Questions for Interview P...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_NUMBER SQL Anal...
#sql #dataengineer
Watch video Acies Global SQL Interview Question | Employee Swipe in and Swipe out online without registration, duration hours minute second in high quality. This video was added by user Ankit Bansal 24 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,49 once and liked it 45 people.