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)

Suppose that each country completely specializes in the production of the good in which it has a comparative advantage, producing only that good. in this case, the country that produces jeans will produce 32 million pairs per month, and the country that produces corn will produce 32 million bushels per month.

Laurelton heating & cooling installs and services commercial heating and cooling systems. laurelton uses job costing to calculate the cost of its jobs. overhead is allocated to each job based on the number of direct labor hours spent on that job. at the beginning of the current year, laurelton estimated that its overhead for the coming year would be $ 61 comma 500. it also anticipated using 4 comma 100 direct labor hours for the year. in april comma laurelton started and completed the following two jobs: (click the icon to view the jobs.) laurelton paid a $ 20-per-hour wage rate to the employees who worked on these two jobs. read the requirements requirement 1. what is laurelton's predetermined overhead rate based on direct labor hours? determine the formula to calculate laurelton's predetermined overhead rate based on direct labor hours, then calculate the rate. / = predetermined overhead rate

Which qualifications have an importance level higher than 60 for a career as a customer service representative? select all that apply operation monitoring mathematics service orientation reading comprehension persuasion learning strategies speaking