ignore my answers CS346 AS: Due Apri a\" 2018 3) The e description, quantity on

Question

ignore my answers

CS346 AS: Due Apri a" 2018 3) The e description, quantity on hold(P Qo ti, the unit price and total price of the inventory, as TOTValue for each product 4) List of all products, the date they were rec s the warranty expiration date (90 days from receiving the product) as ExpDate Seo P- 5) List all the 6) The description, invéntory date (P INDATEL produ ycts supplied Pyvendor,7134|Or 2428 price and the 21 and price is less rice nd the date for each pr produst whose inventory date (P INDATE) is after January 1 7) The description, inventory date (P INDATE uary 15, 2012 and price is less than $50 OR the ver inventory date (P INDATE) is after Jan number is 24288 etcieve all information on products not supplied by vendor 2 1344- PXtr??2:3 9) ?Retriev?'alt informationen produ 10) Listall products that do not avea vendor ass gnedtoth nn and 100 w, 11) List the description and prices of all products ordering them from higher to 12) Retrieve the code, description and price of the most and least expensive product. 13) Retrieve the total customer balance from the table customer 14) Retrieve the product codes, descriptions and the names of the vendors that supply them 15) For each vendor, list all the products they supply

Explanation / Answer

Solution:

The first four subparts have been answered as per Chegg guidelines, please repost others.

3)

SELECT description, P_QOH, unitPrice, SUM(unitPrice) AS TOTValue FROM Product.

4)

SELECT prdoductID, recieveDate, (recieveDate+90) AS ExpDate FROM Product.

5)

SELECT productID FROM Supply WHERE vendorNumber= '21344' OR vendorNumber= '24288'

6)

SELECT description, P_INDATE, price, date FROM Product WHERE (P_INDATE> 'January 15 2015' AND price<'50') OR vendorNumber= '24288'

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.