Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need it as soon as possible please CS346 A5.5: Due Apeil 5 L Ghemei Download the CREATE_P_v.sql file from dropbox Make sure not to

image text in transcribed

I need it as soon as possible please

CS346 A5.5: Due Apeil 5 L Ghemei Download the CREATE_P_v.sql file from dropbox Make sure not to delete any working query as you answer more questions Once all your queries are correct and returning results, set sal to send responses to a fe Email your file to your instructor Write the SQL queries to retrieve the following: 2) The description, quantity on holdP Q0Hl, the minimum quantity and the price for each prodast whose price is below $10.00 2) The description, quantity an holdjP_Q0HI, the minimum quantity, the price and the date for each product whose inventory date IP INDATE) is on or after January 20, 2012 3) The description, quantity on holdlP_00Hl, the unit price and total price of the inventary, as TOTValue for each product. 4) List of all products, the date they were received and the warranty expiratian date (90 days from receiving the product) as ExpDate 5) List all the products supplied by vendor 21344 or 24288 The description, inventory date (P INDATEL, the price and the date for each product whose 6) inventory date (P INDATE) is after January 15, 2012 and price is less than $s0 7) The description, inventory date (P INDATEl, the price and the date for each product whose inventory date (P INDATE) is after January 15, 2012 and price is less than $50 OR the vendor number is 24288 8) Retrieve all inforrmation on products not supplied by vendor 21344 9) Retrieve all information on products whose price is between $5D and $100 10) List all products that do not have a vendor assigned to them 11) List the description and prices of all products ordering them from higher to lower 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Internals A Deep Dive Into How Distributed Data Systems Work

Authors: Alex Petrov

1st Edition

1492040347, 978-1492040347

More Books

Students also viewed these Databases questions