Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

which employees purchased sneakers (made purchases) from the manufacturer named Timberland? Show first and last employee names only. 4 / 10 (40.0%) Select distinct FirstName,

image text in transcribedimage text in transcribed image text in transcribed

image text in transcribed

which employees purchased sneakers (made purchases) from the manufacturer named Timberland? Show first and last employee names only. 4 / 10 (40.0%) Select distinct FirstName, LastName from Employee E join Purchase P on E.EmployeelD - P EmployeeID oin urchaseltem PI on P PurchaseID=PI PurchaselDioin Product PR on PI.ProductiD PR.ProductID Join Manufacturer M on PR.ManufacturerID M.ManufacturerID where PR.Category- sneakers and M.ManufacturerName Timberland Select distinct FirstName, LastName fron Employee E join Purchase P on E.EmployeeID P En loyeeID join Purchaselten Pl on P PurchaseID PI PurchaseID join Product PR on P1 ProductID : PR.ProductID join Manufacturer M on PR-Manufacturer!D M.ManufacturerID where PR.Category sneakers' and M.ManufacturerNane Timberland Keyword distinct eliminates duplicates. Feedback: The system was unable to execute your query so it could not evaluate if it produces the correct number of rows. (-3) Open in Advanced Editor Save Answer Test Query - The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where FirstName-Terry' 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) which employees purchased sneakers (made purchases) from the manufacturer named Timberland? Show first and last employee names only. 4 / 10 (40.0%) Select distinct FirstName, LastName from Employee E join Purchase P on E.EmployeelD - P EmployeeID oin urchaseltem PI on P PurchaseID=PI PurchaselDioin Product PR on PI.ProductiD PR.ProductID Join Manufacturer M on PR.ManufacturerID M.ManufacturerID where PR.Category- sneakers and M.ManufacturerName Timberland Select distinct FirstName, LastName fron Employee E join Purchase P on E.EmployeeID P En loyeeID join Purchaselten Pl on P PurchaseID PI PurchaseID join Product PR on P1 ProductID : PR.ProductID join Manufacturer M on PR-Manufacturer!D M.ManufacturerID where PR.Category sneakers' and M.ManufacturerNane Timberland Keyword distinct eliminates duplicates. Feedback: The system was unable to execute your query so it could not evaluate if it produces the correct number of rows. (-3) Open in Advanced Editor Save Answer Test Query - The system was unable to execute your query so it could not evaluate if it produces the correct number of rows where FirstName-Terry' 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions

Question

LO2 Explain the nature of the psychological contract.

Answered: 1 week ago