Please write queries based on the following requirements usi

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

1. List the employee ID and the full name of the employee who sole or packaged the transactions placed by customer Benjamin Jones. Each employee should only show up once in your results.

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

Solution

Select distinct EMPLOYEES.EmployeeID,EMPLOYEES.First,EMPLOYEES.Last from EMPLOYEES E inner join TRANSACTIONS on EMPLOYEES.EmployeeID = TRANSACTIONS.SoldOrPackagedBy inner join MEMBERS.MmberID =TRANSACTIONS.Member where MEMBERS.First = \'Benjamin\' AND MEMBERS.Last Name = \'JONES\';