Schema Km company database. Vendor (V-code. v-name. v contact. V-STATE. VORDER)

Question

Schema Km company database. Vendor (V-code. v-name. v contact. V-STATE. VORDER) PROOUCT P RESCRIPT. P. INDATE, P_OOM. P MIN. P PRICE. V CODE) INVOICE UNV NUMBER CUS COOE. INV DATE) LINE (INV NUMBER. LINE NUMBER-. P_CODE. LINE_UNITS. LINE_PRICE) CUSTOMER (CUS CODE. CUS.LNAME. CUS FNAME. CUS BALANCE) Finish the following SQL statements. What is the maximum value of P_PRICE ? select (P_PRICE) from PRODUCT How much is the total customer balance? select (CUSBALANCE) from CUSTOMER TOTBALANCE What products have a price that exceeds the average product price? select P CODE. PRESCRIPT. P_PRICE from where P PRICE (select (P_PR1CE) from PRODUCT) List the number of products by vendor, include only the rows with average price below 10.00. select V CODE, DISTINCT P_CODE_)from PRODUCT V_CODE

Explanation / Answer

sql queries

a) select max(p_price) from project

b)select sum(cus_balance) as total_balance from customer

c)select p_code,p_descript,p_price from product where p_price >(select avg(p_price) from product;

d)select v-code,count(distinct p_code) from product where v_code < (select avg(v_code)<10.00 from product)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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