---
# System prepended metadata

title: Home assignment

---

# Home assignment

Task 1:
What is this sql query calculating? What would you name the `result` variable?
```sql=BigQuery
select
    date,
    country,
    count(*) as `result`
from (
    select
        user_id,
        event_date as date,
        any_value(geo.country) as country
    from `zedge-android.events.all`
    where event_date between current_date - interval 2 day and current_date - interval 1 day
    group by user_id, date
)
group by date, country
order by date, count(*) desc
```

Task 2:
A session is defined as a period of activity in the application. If there is a period longer than 5 minutes when the user does not do anything actively the session ends. The session time is the time between the first action to the last action of the session.

Look at the [distribution of session times of two segments A and B](https://redash.zedge.io/public/dashboards/kvar0lW2x51CRucZP0sARFJ6HI7ETsiP9vXJDAty?org_slug=default&p_segment=new_users_last_day&p_num_samples=100).

We want to figure out if segment A is performing different than segment B. Please write **what you would do** to decide if one is better than the other. **Do not calculate any results** but list the metrics you would calculate in the order you would calculate them.



