Please write queries based on the following requirements usi

Please write queries based on the following requirements using Premier Database.

4. List all the full names of the employees who sold item 000078. Show your results in ascending order on employee’s last name.

database:https://onedrive.live.com/redir?resid=A1E5259BDD065B48!4478&authkey=!AH3fj0xU0Jv_Jyc&ithint=file%2caccdb

Solution

The file not opened when I\'m downloading so here is it,

select firstname,lastname from Employee where emp_id in(select DISTINCT emp_id from Sales where item_no=000078) ORDER BY lastname

Here i assumed the table structure like Sales table having employee id and corresponding item no sold