SQL · Snapchat · Easy
Description The activities table stores one row per user action, with these columns: activity_id is the primary key, and activity_type can only be 'send', 'open', or 'chat'. The ages table maps each user to an age group: Here user_id is the primary key, and age_bucket can be '21-25', '26-30', or '31-35'. Write a query that gives a breakdown by age group of the time spent sending versus opening snaps as a percentage of the total time spent on those two activity types. Ignore…
Checking your access…