Sample questions

• Complete the query to return the department name and the number of employees in each department using a CTE.
• Fill in the blank to select employees who earn more than the average salary across all employees.
• Given the following query, what will be its output?