Use this file as your template and place your SQL code {not the results} beneath each question.
Use the following tables to answer the questions:
CUSTOMERS(cid, cname, city, discnt)
AGENTS(aid, aname, city, commission)
PRODUCTS(pid, pname, city, quantity, price)
ORDERS(ordno, ordmonth, cid, aid, pid, qty, dollars)
Construct queries to answer the following:
Use the following tables to answer the questions:
CUSTOMERS(cid, cname, city, discnt)
AGENTS(aid, aname, city, commission)
PRODUCTS(pid, pname, city, quantity, price)
ORDERS(ordno, ordmonth, cid, aid, pid, qty, dollars)
Construct queries to answer the following:
- List the name [cname] of all customers
- List the order number [ordno] of all orders
- List all information about the products
- List the customer ids [cid] of all customers who placed an order. Do not list duplicates.
- List the customer names [cname] for customers in the city of Dallas.
Comments
Post a Comment