Use the relational schema of Pine Valley Furniture (PVF) database system to crea

Question

Use the relational schema of Pine Valley Furniture (PVF) database system to create and execute SQL queries. Here is the relational schema:

pvf_cust (cid, name, address, city, state, zipcode)

pvf_order (oid, orderdate, cid)

     cid is a foreign key references customer(cid)

pvf_product (pid, prod_desc, prod_finish, price, prod_line_id)

pvf_order_item (oid, pid, quantity)

     oid is a foreign key references pvf_order(oid)

     pid is a foreign key references pvf_prod(pid)

1. For each customer, display his/her ID, name, state, and total number of orders placed. "Include those who have never placed an order."

Explanation / Answer

select cid,name,state,count(*)
from pvf_cust cust,pvf_order order
where cust.cid=order.cid(+)

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

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