home study engineering computer science questions and an

home / study / engineering / computer science / questions and answers / please write queries based on the following requirements... Question: Please write queries based on the following requir... Bookmark Please write queries based on the following requirements using Premier Database. Premier Database can be downloaded from Blackboard. You are required to submit SQL query code. You do NOT need to submit your query results. However, it is strongly recommended that you test your queries in Premier Database to make sure your query is accurate.

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 EmployeeId,First,Last
FROM EMPLOYEES
WHERE ((([EmployeeId]) In (SELECT TRANSACTIONS.SoldOrPackagedBy
FROM MEMBERS INNER JOIN TRANSACTIONS ON MEMBERS.MemberID = TRANSACTIONS.MemberID where MEMBERS.First=\'Benjamin\' AND MEMBERS.Last=\'Jones\')));