/course-dbt-greenery-week-1

Answers to the Week-1 Project

1)
    Answer: 130
    Query: select count(*) from public.stg_users;

2)
    Answer: 8,125
    Query: select avg(orders_number) from public.stg_aggregated_hour_orders;

3)
    Answer: 3,92
    Query: select avg(extract(epoch from (delivered_at - created_at))/86400) from public.stg_orders where delivered_at is not null;

4)
    1.
        Answer: 25
        Query: select count(*) from (select user_id from public.stg_orders group by user_id having count(*) = 1) as t;
    2.
        Answer: 22
        Query: select count(*) from (select user_id from public.stg_orders group by user_id having count(*) = 2) as t;
    3.
        Answer: 81
        Query: select count(*) from (select user_id from public.stg_orders group by user_id having count(*) >= 3) as t;

5)
    Answer: 7,38
    Query: select avg(unique_sessions_number) from public.stg_aggregated_hour_unique_sessions;