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.
1) Retrieve the names of employees who sold an item to 'Toy Fowler' on '03-FEB-24'.
2) Retrieve the names of customers who purchased the 'Shimano Trinidad A Casting Reel' product.
3) Retrieve the names of employees who are over 40 years senior to her/his supervisor.
4) Retrieve the names of employees who purchased an item on '18-FEB-24' at the store located in '2300 W Atlantic Blvd, Pompano Beach, Fl 33069'.
5) Retrieve the ids and names of customers who purchased both '2x3 Shield Game, College' and 'Oceanic Alpha 8 Octopus' products.
6) Retrieve the ids and names of customers who purchased the '2x3 Shield Game, College' product, but never purchased the 'Oceanic Alpha 8 Octopus' products.
7) Retrieve the name of customers who purchased all items of the 'Sabon Body Scrub, Delicate Jasmine, 21.2 Oz' product.
8) Retrieve names of customers who purchased and returned the same item on the same date.
9) Retrieve the names of customers who are over 82 years old and purchased the same product on different date.
10)Retrieve the names of categories that has more than 10,000 products.
 Write SQL statements for the following queries. 1) Retrieve the names

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 Databases Questions!