The Queries: 1.Print supplier numbers for suppliers who are located in the same
ID: 3597710 • Letter: T
Question
The Queries:
1.Print supplier numbers for suppliers who are located in the same city as supplier S1. Do not include S1 in the answer.
2.Print supplier numbers for suppliers who ship at least all those parts shipped by supplier S3. Do not include S3 in the answer and do not "count".
3.Print supplier numbers for suppliers who ship at least one type of red part.
4.Print supplier numbers for suppliers who do not ship any red parts.
5.Print supplier numbers for suppliers who ship ONLY red parts.
6.Print supplier names for suppliers who do not currently ship any parts.
7.Print supplier names for suppliers who ship at least one part that is also shipped by supplier S2. Do not include S2 in the answer.
8.Print supplier numbers for suppliers with status value less than the current average status value of all suppliers.
9.Print all the shipment information for the shipment(s) with the highest unit cost (i.e. price).
10.Print all the shipment information for the shipment(s) with the highest total cost, (i.e. price*Qty).
11.Print all the supplier information for the supplier(s) making the most money. The supplier money is determined by the sum of all shipment cost. Each shipment cost is found by the number of units being shipped times the price per unit.
12.For each supplier (including the one who doesn’t ship any parts), print the supplier number and how many different parts shipped. For example, S1 6; S2 2, ...
13.For each supplier (including the one who doesn’t ship any parts), print the supplier number, supplier name, total cost of all shipments, and how many different parts shipped.
Explanation / Answer
Simple retrieval (projection) SELECT P# FROM SP ; Eliminate duplicates SELECT DISTINCT P# FROM SP ; Computed values SELECT P.P#, 'Weight in grams =', P.WEIGHT * 234 FROM P ; Select all columns SELECT * FROM S ; SELECT S.* FROM S ; SELECT S.S#, S.SNAME, S.STATUS, S.CITY FROM S ; SELECT S# FROM S WHERE CITY = 'Paris' AND STATUS > 20 ; The Condition is a logical expression involving AND, OR, NOT, =, , >, >=,Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.