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?