Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
★★★★★
3.54 Rating (147 Votes )
There are 3 Steps involved in it
Step: 1
Answer step 1 SELECT Pproductname FROM Products P JOIN Orders O ON Pproductid O...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