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)

Kyle and alyssa paid $1,000 and $4,000 in qualifying expenses for their two daughters jane and jill, respectively, to attend the university of california. jane is a sophomore and jill is a freshman. kyle and alyssa's agi is $135,000 and they file a joint return. what is their allowable american opportunity tax credit after the credit phase-out based on agi is taken into account?

What additional information about the numbers used to compute this ratio might be useful in you assess liquidity? (select all that apply) (a) the maturity schedule of current liabilities (b) the average stock price for the industry (c) the average current ratio for the industry (d) the amount of current assets that is concentrated in relatively illiquid inventories

The east asiatic company (eac), a danish company with subsidiaries throughout asia, has been funding its bangkok subsidiary primarily with u.s. dollar debt because of the cost and availability of dollar capital as opposed to thai baht-denominated (b) debt. the treasurer of eac-thailand is considering a 1-year bank loan for $247,000.the current spot rate is b32.03 /$, and the dollar-based interest is 6.78% for the 1-year period. 1-year loans are 12.04% in baht.a. assuming expected inflation rates of 4.3 % and 1.24% in thailand and the united states, respectively, for the coming year, according to purchase power parity, what would the effective cost of funds be in thai baht terms? b. if eac's foreign exchange advisers believe strongly that the thai government wants to push the value of the baht down against the dollar by5% over the coming year (to promote its export competitiveness in dollar markets), what might the effective cost of funds end up being in baht terms? c. if eac could borrow thai baht at 13% per annum, would this be cheaper than either part (a) or part (b) above?