Reference no: EM131092074
In the following exercises, you will use the data in the TAL Distributors database (If you use a computer to complete these exercises, use a copy of the original TAL Distributors database so you will still have the original data when you complete Chapter 4.) In each step, use SQL to obtain the desired results. You can use a DBMS to complete the exercises using a computer, or you can simply write the SQL command to com-plete each step. Check with your instructor if you are uncertain about which approach to take.
1. List the number and name of all customers.
2. List the complete Item table.
3. List the number and name of every customer represented by rep 15.
4. List the number and name of all customers that are represented by rep 15 and that have credit limits of $10.000.
5. List the number and name of all customers that are represented by rep 15 or that have credit limits of $10,000.
6. For each order, rist the order number, order date, number of the customer that placed the order, and name of the customer that placed the order.
7. List the number and name of all customers represented by Megan Gradey.
8. How many customers have a credit limit of $15,000?
9. Find the total of the balances for all customers represented by rep 30.
10. Give the item number. description, and on-hand value (Onlland • Price) for each item in category GME.
11. List all columns and all rows in the Item table. Sort the results by Item description.
|
Calculate the rate of return for the invested money
: A permanent scholarship fund is started through a donation of $100000. If five scholarships of $5000 each are awarded each year beginning ten years from now, Calculate the rate of return for the invested money.
|
|
Firm total and per-unit cost functions over range of output
: Assume that a novelty T-shirt producer has determined that her firm’s weeklynshort-run cost data can be summarized by a linear total cost function. Currently, the firm’s fixed overhead costs (rent, depreciation, etc.) amount to $2,100 per week, and t..
|
|
What will be the impact on the trade balance
: Suppose that each one percent depreciation in the US dollar induces a 0.75 increase in exports and a 0.25 decrease in imports. Starting from a position where exports equals imports, what will be the impact on the trade balance
|
|
List the number and name of all customers
: In the following exercises, you will use the data in the TAL Distributors database (If you use a computer to complete these exercises, use a copy of the original TAL Distributors database so you will still have the original data when you complete Cha..
|
|
Manufacturer faces cobb-douglas production function
: Assume that a manufacturer faces a Cobb-Douglas production function, q= 40K^0.5L^0.5 where q is output per period, L is labor, K is capital
|
|
Identify the type of anti-competitive behavior
: Identify the type of anti-competitive behavior illustrated by each of the following: (also note the piece of legislation that declares this type of behavior as [potentially] illegal). Calculate the Herfindahl-Hirschman (HHI) index for the for the fol..
|
|
A theory of motivation presented in our e-text
: •Be sure you have the facts of the case correct and that you explain and apply the theory correctly. Selecting appropriate theories is only good when you can show that you understand the theory and apply it accurately
|
|
Examine the data in table 4 showing the amount of dissolve
: Make an observation - Based on the data in Table 4, describe the relationship between dissolved oxygen content and fish populations in the body of water. Discuss the pattern observed in the data set.Answer =
|