# 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.
Click the virtual machine below to start practicing