Answered step by step
Verified Expert Solution
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
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 supplyStep by Step Solution
There are 3 Steps involved in it
Step: 1
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