Question: Write SQL statements for the following queries. 1) Retrieve all names of products that were purchased by 'Kailani Benham' on 29-0323 at the store located

 Write SQL statements for the following queries. 1) Retrieve all names

Write SQL statements for the following queries. 1) Retrieve all names of products that were purchased by 'Kailani Benham' on 29-0323 at the store located at '22100 Fl-7, Boca Raton, FI 33428'. 2) Retrieve the ids and the first and last names of employees who have no supervisor and are older than 80 . 3) Retrieve the ids and the first and last names of customers who purchase the 'Seasense Rope Ladder' product. 4) Retrieve the ids and the first and last names of customers who purchase no item. 5) Retrieve the ids and the first and last names of customers who purchase 'Seasense Rope Ladder' or 'Sloth Face Ice Hockey Puck' products. 6) Retrieve the ids and the first and last names of customers who purchase both 'Seasense Rope Ladder' and 'Sloth Face lce Hockey Puck' products. 7) Retrieve the first and last names of the oldest customers whose salary is greater than 400000 . 8) Retrieve the names of brands whose brand value is greater than 98 and contains more than 10 products. 9) Retrieve the first and last names of customers who purchase and return the same item on the same date. 10)Retrieve the first and last names of customers who purchases all items of the ' Q Tees Hemmed Fingertip Towel' product

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!