Sql Refresher #4

Problem: Select all orders processed by a Sales Representative

Solution: 

select * from orders where 
employee_id in ( select id from employees where employees.job_title = 'Sales Representative')

Comments