Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started