Write SQL statements for the following queries. 1) Retrieve all names of products that were purchased...

  

Transcribed Image Text:

Write SQL statements for the following queries. 1) Retrieve all names of products that were purchased by 'Kailani Benham' on 29-03- 23 at the store located at '22100 FI-7, Boca Raton, Fl 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 Ice 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 'QTees Hemmed Fingertip Towel' product. REFUND CD INTEGER PD INTEGER INTEGER NO RDATE DATE PURCHASE CD INTEGER ED INTEGER PID INTEGER INTEGER NO PDATE DATE CUSTOMER D INTEGER FNAME VARCHAR2(20) LNAME VARCHAR2(20) AGE INTEGER SALARY INTEGER ITEM PID INTEGER NO INTEGER SID INTEGER PRODUCTCATEGORY PD INTEGER CAT_ID INTEGER > EMPLOYEE D INTEGER FNAME VARCHAR2(20) INAME VARCHAR2(20) AGE INTEGER SUP EID INTEGER STORE D INTEGER ADDRESS VARCHAR2(50) PRODUCT D NAME VARCHAR2(210) PRICE NUMBER BID INTEGER INTEGER CATEGORY D INTEGER NAME VARCHAR2(90) " BRAND INTEGER VARCHAR2(70) NAME BRAND_VALUE INTEGER Write SQL statements for the following queries. 1) Retrieve all names of products that were purchased by 'Kailani Benham' on 29-03- 23 at the store located at '22100 FI-7, Boca Raton, Fl 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 Ice 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 'QTees Hemmed Fingertip Towel' product. REFUND CD INTEGER PD INTEGER INTEGER NO RDATE DATE PURCHASE CD INTEGER ED INTEGER PID INTEGER INTEGER NO PDATE DATE CUSTOMER D INTEGER FNAME VARCHAR2(20) LNAME VARCHAR2(20) AGE INTEGER SALARY INTEGER ITEM PID INTEGER NO INTEGER SID INTEGER PRODUCTCATEGORY PD INTEGER CAT_ID INTEGER > EMPLOYEE D INTEGER FNAME VARCHAR2(20) INAME VARCHAR2(20) AGE INTEGER SUP EID INTEGER STORE D INTEGER ADDRESS VARCHAR2(50) PRODUCT D NAME VARCHAR2(210) PRICE NUMBER BID INTEGER INTEGER CATEGORY D INTEGER NAME VARCHAR2(90) " BRAND INTEGER VARCHAR2(70) NAME BRAND_VALUE INTEGER

Answer rating: 100% (QA)

Answer step 1 SELECT Pproductname FROM Products P JOIN Orders O ON Pproductid O... View the full answer