SQL Subqueries for Data Analysis | Challenge

# Introduction In this challenge, we'll use subqueries to retrieve useful information from the employee and department tables in our personnel database. Tasks will involve identifying the highest-paid employee, locating the department with a specific number and calculating the ratio of employees in that department, locating employees working in New York, and querying employees whose salaries exceed the average salary of their department.

|
60 : 00

Click the virtual machine below to start practicing