Skip to content

3056. Snaps Analysis

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
SELECT
  Age.age_bucket,
  ROUND(
    SUM(IF(Activities.activity_type = 'send', Activities.time_spent, 0)) /
    SUM(Activities.time_spent) * 100,
    2
  ) AS send_perc,
  ROUND(
    SUM(IF(Activities.activity_type = 'open', Activities.time_spent, 0)) /
    SUM(Activities.time_spent) * 100,
    2
  ) AS open_perc
FROM Activities
INNER JOIN Age
  USING (user_id)
GROUP BY 1;