Need to write the following SQL queries for the schema provided in the screenshot as well as the DDL in text file. This should be simple for any SQL programmer, I'm new to SQL and having trouble
all queries should be written in the form:
SELECT 
FROM
WHERE

GROUP BY
HAVING

1.Return the product names and inventory value of each product (price*inventory) ordered by descending inventory value.

1. 2.Return total number of products ordered (amountfield inShippedProduct).
2. 3.For all customers in either Iowa ('IA') or California ('CA') list the customer name, product name, and amount for all shipments.
3. 4.Return the customers (cid,cname) (no duplicates) whose address contains the word 'Street' and have received at least one shipment.
4. 5.Return the products (pid, pname) that are shipped more (in terms ofamount) than the average total amount each product is shipped. E.g. If total amount that 4 products are shipped is 15,5,30,10. The average total amount each is shipped is 15, and only the 3rd product with total amount 30 is above the average.
5. 6.Return the list of products (no duplicates) that have never been in a shipment.
6. 7.Return a list of states and the number of customers in each state.
7. 8.Return a list of states and the total value of all shipments to customers in that state. Only show states whose total value is greater than $5000.
8. 9.Return a list of products (id and name) along with the number of times it has been shipped, the total amount of all shipments, and the total value of all shipments. Only consider shipments after January 13th, 2014, and only show products if they have been shipped at least 3 times.
9. 10.Return all customers and their states that share a state with another customer.

• 1500648642-databaseshipmentddl.rtf
• 1500648642-Screen Shot 2016-10-04 at 10.29.10 PM.png

APlusGrades

Not Rated (0)

Status NEW Posted 21 Jul 2017 02:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer