Need help answering the SQL questions at bottom of the document

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4

JoinsFind all Employees and the Sales Office they work at .SELECT*FROM Employee , Sales OfficeWhere Employee . Office Number = Sales Office . Office Number ;Return the Properties that each Sales Office has .SELECT Sales Office . Office Number , Property IDFROM Sales Office , PropertiesWHERE Sales Office . Office Number = Properties . Office Number;

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

What are the major issues emphasized in corporate social responsibility? How are these issues related to traditional marketing and to the rise of the consumer class? How is sustainability marketing different from conventional marketing, and how is it related to it?

In the current scenario, many businesses are involved in social activities in one form or the other.It is important for the organizations to consider Corporate Social Responsibility, so that they…

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Joni Marin Inc. has the following amounts reported in its general ledger at the end of the current year.

Organization costs

$23,300Trademarks

14,700Discount on bonds payable

36,300Deposits with advertising agency for ads to promote goodwill of company

11,300Excess of cost over fair value of net identifiable assets of acquired subsidiary

76,300Cost of equipment acquired for research and development projects; the

   equipment has an alternative future use

86,300Costs of developing a secret formula for a product that is expected to

   be marketed for at least 20 years

81,600

(a)

On the basis of this information, compute the total amount to be reported by Marin for intangible assets on its balance sheet at year-end.

Total amount reported for intangible assets

$

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Jones was engaged to examine the financial statements of Gamma Corporation for the year ended June 30. Having completed an examination of the investment securities, which of the following is the best method of verifying the accuracy of recorded dividend income?a. Tracing recorded dividend income to cash receipts records and validated deposit slips.b. Utilizing analytical procedures and statistical sampling.c. Comparing recorded dividends with amounts appearing on federal information Form 1099.d. Comparing recorded dividends with a standard financial reporting service’s record of dividends.

4. Jones was engaged to examine the financial statements of Gamma Corporation for the yearended June 30. Having completed an examination of the investment securities, which of thefollowing is the…

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Mr. Jones Smith want’s to buy Smithon Manufacturing because it is very profitable. Right now it has 30 shareholders but no single majority shareholder. It is a C corporation with a fiscal year-end of December 1. In order for me to buy this company, I will need to invest a lot of money in new manufacturing equipment, which means that Smithon will incur a loss for two years. I want to buy the company effective January 1. I think I should buy the company from the shareholders and convert it to an S corporation. Also, I want a fiscal year-end that is also a calendar year-end, i.e., December 31. We should consider whether I could issue shares of stock from Johnson Services which is a C corporation to the shareholders of Smithon in an exchange of shares. That way, the current Smithon owners would become new shareholders (but not owners) of Johnson Services and I would get all their shares of Smithon. If I do so, I could probably offset Smithon’s profits with the losses from Johnson Services.1.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"