Question: Write SQL statements for the following queries. 1 ) Retrieve the names of employees who sold an item to 'Toy Fowler' on ' 0 3
Write SQL statements for the following queries.
Retrieve the names of employees who sold an item to 'Toy Fowler' on FEB
Retrieve the names of customers who purchased the 'Shimano Trinidad A Casting Reel' product.
Retrieve the names of employees who are over years senior to herhis supervisor.
Retrieve the names of employees who purchased an item on FEB at the store located in W Atlantic Blvd Pompano Beach, Fl
Retrieve the ids and names of customers who purchased both x Shield Game, College' and 'Oceanic Alpha Octopus' products.
Retrieve the ids and names of customers who purchased the x Shield Game, College' product, but never purchased the 'Oceanic Alpha Octopus' products.
Retrieve the name of customers who purchased all items of the 'Sabon Body Scrub, Delicate Jasmine, Oz product.
Retrieve names of customers who purchased and returned the same item on the same date.
Retrieve the names of customers who are over years old and purchased the same product on different date.
Retrieve the names of categories that has more than products.
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
