BI SQL (Coding)

60 Minutes

4 Questions

This test is designed to assess the advanced SQL skills required for Data Analysts and Business Intelligence (BI) professionals. The test focuses on complex query writing, advanced data manipulation, and optimization techniques in SQL. Candidates will be evaluated on their ability to handle large datasets, write efficient queries, and extract meaningful insights from data.

Example Question:

Coding

Consider the following Employee schema:

TABLE Employee

EmployeeID int NULL,

EmployeeName nvarchar(50) NULL,

ManagerID int NULL,

DepartmentID int NULL,

Salary float NULL

Please write a T-SQL query to display all the employees that their manager is not working in the same department as them

The following columns should be displayed

EmployeeID EmployeeName ManagerID DepartmentID Salary

- The manager is also an employee

- An employee that does not have a manager should also be listed.

- To view the table data, type: "select * from Employee" and press on Run SQL