Reference no: EM1362324
CUSTOMER ( Cid, CName, City, Discount )
AGENT ( Aid, AName, City, Percent )
PRODUCT ( Pid, PName, City, Quantity, Price )
ORDERS ( OrderNo, Month, Cid, Aid, Pid, OrderedQuantity, Cost )
Write the appropriate SQL statements that perform the following queries: ( Solve part 10, 11 and 12, only when you finished all the previous queries to avoid changing the data. )
You must change the name of any manipulated column.
1) List the names of agents that placed an order for customer C003 or customer C006.
2) List all pair of products names that are in the same city, along with their city name.
3) List the number of orders and their total cost for each agent that handled orders with more than $1,000 in total; showing the agent name.
4) List the names of all customers and the total cost of their orders if they have placed an order.
5) List the id and the name of products that were not ordered through agents 'A04'.
|
List out some of your variable costs and describe it
: Suppose you and your roommate have started a bagel delivery service on campus. List some of your fixed costs and describe why they are fixed. List out some of your variable costs and describe why they are variable.
|
|
Pros and cons of various ergogenic aids
: Name and describe the pros and cons of various ergogenic aids: caffeine, carnitine, chromium picolinate, creatine, amino acids and protein powders?
|
|
Explain the process average and range in statistical control
: Explain the process average and range in statistical control and Is the process capable of meeting the design standard at four-sigma quality
|
|
Indicate the short-run price elasticity of demand for tires
: Indicate what the short-run price elasticity of demand for tires is 0.9. If a tire store raise the price of a tire from $50 to $60, by the price elasticity of demand.
|
|
List all pair of products names which are in same city
: List the names of agents that placed an order for customer C003 or customer C006. List all pair of products names that are in the same city, along with their city name.
|
|
Risk-averse with the utility of money
: Supposer two individuals living in the country of Depressia. Depressian banking system is very unstable. On average, 5 percent of all banks collapse every year.
|
|
Prevention of cardiovascular disease
: How are nutrition and immunity are related? Also, describes what cardiovascular disease is, risk factors for cardiovascular disease, prevention of cardiovascular disease, and diet factors that affect cancer risks.
|
|
Write program to calculate how much person earns
: Write a program that calculates how much a person earns in a month if the salary is one penny the first day, two pennies the second day.
|
|
Child thinking or cause misbehavior
: Explain how nutrient deficiencies impair a child's thinking or cause misbehavior?
|