DELOITTE SQL INTERVIEW QUESTION | JSON output

DML: DROP TABLE IF EXISTS Employee; -- Create the Employee table CREATE TABLE Employee ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Salary DECIMAL(10, 2), HireDate DATE, IsActive INT ); -- Insert data into the Employee table INSERT INTO Employee (EmployeeID, FirstName, LastName , Salary, HireDate, IsActive) VALUES (1, 'John', 'Doe' , 70000.00, '2021-03-15', 1), (2, 'Jane', 'Smith' , 65000.00, '2019-07-01', 1), (3, 'Michael', 'Brown' , 80000.00, '2018-08-20', 0), (4, 'Emily', 'Davis' , 72000.00, '2020-01-10', 1), (5, 'Robert', 'Miller' , 60000.00, '2022-05-25', 0), (6, 'Linda', 'Wilson' , 90000.00, '2017-11-30', 1); DROP TABLE IF EXISTS EmployeeDepartments; -- Create the EmployeeDepartments table CREATE TABLE EmployeeDepartments ( EmployeeID INT, Department VARCHAR(50) ); -- Insert data into the EmployeeDepartments table INSERT INTO EmployeeDepartments (EmployeeID, Department) VALUES (1, 'IT'), (1, 'Security'), (2, 'HR'), (3, 'Finance'), (3, 'Compliance'), (4, 'IT'), (4, 'Support'), (5, 'Marketing'), (5, 'Sales'), (6, 'Finance'), (6, 'Auditing'); Feedback: https://forms.gle/NQuCAy7p5a9wxW3LA Playlists: SQL Interview Questions: https://www.youtube.com/playlist?list=PLNlYnu7poveKW915P7Yafz3mNqnIefh3e Recursive CTE: https://www.youtube.com/playlist?list=PLNlYnu7poveK0ySrsIgUihCCryXo-KQj6 PySpark Interview Questions: https://www.youtube.com/playlist?list=PLNlYnu7poveI0umHioVrs6yI6ruP2wy5M Power BI and DAX: https://www.youtube.com/playlist?list=PLNlYnu7poveIK-Fjk7j9xE_9k9tlWFnEE Data Modeling: https://www.youtube.com/playlist?list=PLNlYnu7poveKKEKmJBbvTfyazt6aUiGCw Generative AIs: https://www.youtube.com/playlist?list=PLNlYnu7poveJ6F2xspS7nOZqDV0-G-cmd Excel: https://www.youtube.com/playlist?list=PLNlYnu7poveKW8q_NFOOEew8xA44Y_4kt Cricket: https://www.youtube.com/playlist?list=PLNlYnu7poveJ7pXb00jftk5yoTtuoQjaY SQL ADVANCED AGGREGATIONS: https://www.youtube.com/playlist?list=PLNlYnu7poveJ0ei855_X_gy_ZEj_z4vz1 Follow me Linkedin: https://www.linkedin.com/in/data-sculptor-93a00b2a8 Instagram: https://www.instagram.com/datasculptor2895