Write a query to list all employees (show all columns) and their jobs on various projects. Include employees that do NOT work on any jobs

Gino's restaurant is a popular restaurant in boston, massachusetts. the owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. the intern, in consultation with the owner, identified the following major activities: activity cost pool activity measure serving a party of diners number of parties served serving a diner number of diners served serving drinks number of drinks ordered some costs, such as the cost of cleaning the linens that cover the restaurant's tables, vary with the number of parties served. other costs, such as washing plates and glasses, depends on the number of diners served or the number of drinks served. data concerning these activities are shown below. serving a party serving a dinner serving drinks total total cost $47,600 $153,000 $59,800 $260,400 total activity 7,000 parties 30,000 diners 46,000 drinks prior to the activity-based costing study, the owner knew very little about the costs of the restaurant. she knew that the total cost for the month was $260,400 and that 30,000 diners had been served. therefore, the average cost per diner was $8.68.required: 1. compute the activity rates for each of the three activities 2. according to the activity-based costing system, what is the total cost of serving each of the following parties of diners? a. a party of four diners who ordered three drinks in total b. a party of two diners who do not order any drinks c. a lone diner who orders two drinks 3. convert the total costs you computed in part (1) above to costs per diner. in other words, what is the average cost per diner for serving each of the following parties: a. a party of four diners who order three drinks in total b. a party of two diner who do not order any drinks c. a lone diner who orders two drinks 4. why do the costs per diner for the three different parties differ from each other and from the overall average coast of $9.80 per diner?

Afreelance​ singer-songwriter is planning the restoration of a recently purchased civil​ war-era farmhouse. while he professes an enjoyment​ of, and talent in the construction​ trades, the theory of comparative advantage implies that a. the value of what he imports​ (in this​ case, professional contractor​ services) must equal the value of what he exports​ (songs). b. he should concentrate on the restoration work since his​ out-of-pocket costs will be much lower than if he hires professionals. c. ​self-sufficiency is​ advantageous, hence he should split his time between music and construction. d. the income lost while away from music will likely exceed the savings realized by doing the work​ himself, thus, he should hire professionals to do the restoration work. e. he ought to do as much of the work himself as possible since imports​ (in this​ case, professional contractor​ services) should always be restricted to those things that cannot be done internall

Allie and sarah decided that they want to purchase renters insurance for the apartment they share. they made a list of all of the items to be covered by the insurance policy, along with their estimated values. if the items to be covered total more than $3000, the insurance company charges an annual premium of 23% of the total value of the items. if the items to be covered total $3000 or less, the insurance company charges an annual premium of 20% of the total value of the items.