Hello!  Can you provide me with a list of all employee IDs and their corresponding salaries?
select employee_id, salary from employees
Awesome!  That's great! Can you filter this list to show only the employee IDs and correpsonding salaries that are above the average salary?
select employee_id, salary from employees where salary > ( select avg ( salary ) from employees )
Great!  Now can you display this list to include both the first and last name corresponding to each employee ID?
select employee_id, first_name, last_name, salary from employees where salary > ( select avg ( salary ) from employees )
Thank you so much for that! Can you filter this list to show only the rows in which the employee works in a department which has an employee with the letter J in their name?
select employee_id, first_name, last_name, salary from employees where salary > ( select avg ( salary ) from employees ) and department_id in ( select department_id from employees where first_name like '%j%' )