SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Select e.first_name, e.last_name, d.department_name, c.country_name from hr.employees e, hr.departments d, hr.countries c, hr.locations l Where e.department_id=d.department_id and d.location_id=l.location_id and l.country_id=c.country_id and c.country_name=’United States of America’ and d.department_name in (‘Shipping’, ‘Finance’) Order by e.last_name

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear