Question: 1 3 Which employees made purchase orders ( purchases ) from the manufacturer named Timberland? Only show employee first and last names. SELECT DISTINCT e
Which employees made purchase orders purchases from the manufacturer named Timberland? Only show employee first and last names.
SELECT DISTINCT eFirstName, eLastName
FROM Employee
JOIN Purchase ON Employee.EmployeeID Purchase.EmployeeID
WHERE LOWERPurchaseManufacturerName 'timberland'
FEEDBACK
Feedback:
The system was unable to execute your query so it could not evaluate if it produces the correct number of rows.
The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where FirstName'Jerry' and LastName'Scranton'.
The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where FirstName'Kristen' and LastName'Browner'.
The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where FirstName'Kyle' and LastName'Sisk'.
The system was unable to execute your query so it could not evaluate if it produces a column named FirstName.
The system was unable to execute your query so it could not evaluate if it produces a column named LastName.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
