Business, 11.12.2019 17:31 destinyterrea

1. in the sales orders database, how many orders are for only one product? (hint: use a subquery in the from clause that lists the order numbers for orders having only one row and then count those rows in the main query.) (1 row, final result should be 133)

2. in the entertainment agency database, show each agent's name, the sum of the contract price for the engagements they booked, and the agent's total commission for agents whose total commission is more than $1000. sort the list from highest total contracts to lowest. make sure the total commission appears with two decimal places. (4 rows)

3. using the school scheduling database, provide the full name of every staff member and the number of classes they have taught in order from most classes to fewest. (27 rows)

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 08:00

Why is it vital to maintain a designer worksheet? a. it separates the designs chosen for the season from those rejected by the company. b. it keeps a record of all designs created by the designer for a season. c. it charts out the development of an entire line through the season and beyond. d. it tracks the development of a design along with costing and production details. done

Answers: 1

Answer

Business, 22.06.2019 12:50

You are working on a bid to build two city parks a year for the next three years. this project requires the purchase of $249,000 of equipment that will be depreciated using straight-line depreciation to a zero book value over the three-year project life. ignore bonus depreciation. the equipment can be sold at the end of the project for $115,000. you will also need $18.000 in net working capital for the duration of the project. the fixed costs will be $37000 a year and the variable costs will be $148,000 per park. your required rate of return is 14 percent and your tax rate is 21 percent. what is the minimal amount you should bid per park? (round your answer to the nearest $100) (a) $214,300 (b) $214,100 (c) $212,500 (d) $208,200 (e) $208,400

Answers: 3

Answer

Business, 22.06.2019 14:20

Anew 2-lane road is needed in a part of town that is growing. at some point the road will need 4 lanes to handle the anticipated traffic. if the city's optimistic estimate of growth is used, the expansion will be needed in 4 years and has a probability of happening of 40%. for the most likely and pessimistic estimates, the expansion will be needed in 8 and 15 years respectively. the probability of the pessimistic estimate happening is 20%. the expansion will cost $ 4.2 million and the interest rate is 8%. what is the expected pw the expansion will cost?

Answers: 1

Answer

Business, 22.06.2019 19:40

You estimate that your cattle farm will generate $0.15 million of profits on sales of $3 million under normal economic conditions and that the degree of operating leverage is 2. (leave no cells blank - be certain to enter "0" wherever required. do not round intermediate calculations. enter your answers in millions.) a. what will profits be if sales turn out to be $1.5 million?

Answers: 3

Answer

You know the right answer?

1. in the sales orders database, how many orders are for only one product? (hint: use a subquery i...

Questions