Now that you've seen how subqueries work, it's time to get some practice writing them! Not all of the queries will require subqueries, but all will be a bit more complex and require some thought and ...

-- Find all employees who earn more than the average salary of the entire company.