Please write queries based on the following requirements usi

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

-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

select m.first,m.last

from member m,ransactions t ,transaction_details td

where t.transactionid=tid.transactiontd and tid.itemcode==000078

and t.member=m.memberid

order by m.last