Question: 1 3 Which employees made purchase orders ( purchases ) from the manufacturer named Timberland? Only show employee first and last names. SELECT DISTINCT e

13 Which employees made purchase orders (purchases) from the manufacturer named Timberland? Only show employee first and last names.
SELECT DISTINCT e.FirstName, e.LastName
FROM Employee
JOIN Purchase ON Employee.EmployeeID = Purchase.EmployeeID
WHERE LOWER(Purchase.ManufacturerName)= 'timberland'
FEEDBACK
\(2/10\)(20.0\%)
Feedback:
- The system was unable to execute your query so it could not evaluate if it produces the correct number of rows. (-3)
- 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'. (-1)
- 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'. (-1)
- 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'. (-1)
- The system was unable to execute your query so it could not evaluate if it produces a column named FirstName. (-1)
- The system was unable to execute your query so it could not evaluate if it produces a column named LastName. (-1)
1 3 Which employees made purchase orders (

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!