1. For all the statistics of the website with id = 1, show the day, the number of users and the number of users on the next day.
2. Write the query that calculates day-to-day differences in clicks between the current day and the next day.
3. What does the clicks difference infer?
4. Take the statistics for the website with id = 2 between 1 and 14 May 2016 and show the day, the number of users and the number of users 7 days later.
 


 

Transcribed Image Text:

Table: statistics website_id 1 Table: website id 1 2 3 day 2016-05-01 2016-05-02 2016-05-03 2016-05-04 2016-05-05 2016-05-06 2016-05-07 2016-05-08 2016-05-09 2016-05-10 2016-05-11 2016-05-12 2016-05-13 2016-05-14 2016-05-15 2016-05-16 2016-05-17 2016-05-18 2016-05-19 2016-05-20 name Gaming Heaven All About Health Around The World users 36169 29580 30907 19154 10897 24602 19882 26932 39275 28900 23714 19006 24791 27617 8563 33679 25123 32233 33504 10830 budget 3000 700 500 impressions 108507 295800 463605 57462 163455 369030 139174 296252 117825 317900 142284 171054 198328 165702 59941 303111 175861 225631 335040 86640 opened 2016-02-01 2016-03-15 2016-05-01 clicks 237 793 1545 160 343 804 348 782 342 1029 423 378 526 407 135 609 383 594 857 229 revenue 66.34 214.12 401.79 38.31 99.58 184.92 76.55 117.25 68.3 236.62 84.69 101.95 89.43 85.5 33.75 121.73 57.47 118.75 197.08 52.58 Table: statistics website_id 1 Table: website id 1 2 3 day 2016-05-01 2016-05-02 2016-05-03 2016-05-04 2016-05-05 2016-05-06 2016-05-07 2016-05-08 2016-05-09 2016-05-10 2016-05-11 2016-05-12 2016-05-13 2016-05-14 2016-05-15 2016-05-16 2016-05-17 2016-05-18 2016-05-19 2016-05-20 name Gaming Heaven All About Health Around The World users 36169 29580 30907 19154 10897 24602 19882 26932 39275 28900 23714 19006 24791 27617 8563 33679 25123 32233 33504 10830 budget 3000 700 500 impressions 108507 295800 463605 57462 163455 369030 139174 296252 117825 317900 142284 171054 198328 165702 59941 303111 175861 225631 335040 86640 opened 2016-02-01 2016-03-15 2016-05-01 clicks 237 793 1545 160 343 804 348 782 342 1029 423 378 526 407 135 609 383 594 857 229 revenue 66.34 214.12 401.79 38.31 99.58 184.92 76.55 117.25 68.3 236.62 84.69 101.95 89.43 85.5 33.75 121.73 57.47 118.75 197.08 52.58

Answer rating: 100% (QA)

Question What does the clicks difference infer Answer The clicks difference between two consecutive days can infer a number of things including Change... View the full answer