Question: i) USE SQL: We have the following sample dataset (table name: accounts ) listed directly below for Q3-2017 revenue account_id Quarter Revenue 1 Q3-2017 $450

i) USE SQL:

We have the following sample dataset (table name: accounts ) listed directly below for Q3-2017 revenue

account_id Quarter Revenue 1 Q3-2017 $450 2 Q3-2017 $800 3 Q3-2017 $1789 4 Q3-2017 $100 5 Q3-2017 $1200 List the number of accounts in these different spend ranges: $0-$500 $501-$1000 $1001-$1500 ?$1500 Answer set based on the above table Range Number of accounts $0-$500 2 $501-$1000 1 $1001-$1500 1 ?1500 1 Use SQL to solve this one.

ii) Consider the below table. It contains quarterly revenue of accounts from Q1-2016 to Q3-2017. The view below contains only a sample of the data, the original dataset contains thousands of accounts. account_id quarter revenue 1 Q1-2016 $500 1 Q2-2016 $400 1 Q3-2016 $350 1 Q4-2016 $600 1 Q1-2017 $1000 1 Q2-2017 $650 1 Q3-2017 $890 Use SQL statements to transpose the data into the below table format: account_id 2016 Q1-2017 Q2-2017 Q3-2017 1 $1850 $1000 $650 $890 2 --- --- -- -- 3 --- --- -- --

And How much revenue for account_id 1 is forecasted for Q4-2017 based on the data in question 2a? Feel free to use SQL or R statements to solve.

iii) Consider a company has 1000 advertisers and each advertiser generates $500 per month in 2017. In 2018, monthly revenue of each advertiser is $600, the company wants their yearly revenue to be 26% more than 2017. How many more advertisers should be acquired?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Income Statement of an interior design firm, Grand Designs, that makes money by selling hours (fees) and by selling furniture or other items (Sale of Goods). 1) Using the formula for Profit Margin,...

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

I've attached the assignment as a word file, thanks! You can use the class readings for this week's assignments. c05MerchandisingOperationsandtheMultiple-StepIncomeStatement.qxd 8/14/10 2:14 PM Page...

I've attached the question as a word file as well as the class text to help with the assignment. Thanks! c05MerchandisingOperationsandtheMultiple-StepIncomeStatement.qxd 8/14/10 2:14 PM Page 226...

Financial Statement analysis - Homework case number 4. Accounting for Software Revenue Recognition Is Computer Associates Being Too Aggressive? Annual Revenues at Computer Associates (CA) dropped...

need help for Question 1 and 2 of the assignment fir ACCT 221 FORENSIC BUSINESS INVESTIGATION. Pertains to WorldCom scandal. QAssuming WorldCom was a company operating in Australia at the time of the...

You will write a thorough analysis of Verizon Communications Inc. (VZ)'sannual report. The report should contain professional terminology as well as proper grammar and spelling. Please don't CUT and...

You will write a thorough analysis of a company's annual report. The report should contain professional terminology as well as proper grammar and spelling. Please don't CUT and PASTE from web sites...

It is Snapchat A which is found in your course pack. You are to turn in an excel a) excel spreadsheet with formulas for calculations. The spreadsheet should show cash flow, WACC calculation, firm...

Consider Review Exercise 5.101. Suppose if is important, that the overall system be as near perfect as possible. Assuming the: quality of the screens are: as indicated in Review Exercise 5.101, (a)...

You are the communications officer for an events company, which is bringing back a major food festival. You have been asked to write a speech for your CEO to deliver at a tourism conference,...

Auditor's working papers are a form of audit evidence and should be kept in a secure and safe place as well as retained for only 2 years. True False

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Debate the diffi culties that could emerge with the direct transfer of Western HRM methods into a Gulf country. What approaches should you adopt to avoid these diffi culties?

In the Meteor case study, Sarah has put together a comprehensive human resource plan. Think about what could go wrong or what diffi culties could be faced and work out how you could deal with these...

Read the article about the staff shortages in Essex County Council. Think of other areas where there are shortages of professional staff (accounting, legal, planning, hospitals) and suggest ideas how...