gistfile1.txt

## Sessions

### Query

select 
    entry_datetime::date as entry_date,
    sum(bootups) as bootups,
    sum(sessions) as sessions,
    sum(new_users) as new_users
from sessions 
group by entry_date

### Result

entry_date	bootups	sessions	new_users
2017-01-31	135952	135828	33309
2017-01-30	586225	585702	136638

## Active users

### Query

select 
    au.entry_date,
    sum(au.counter) as active_users
from 
    active_users as au
group by 
    entry_date
order by entry_date desc
limit 2

### Result

entry_date	active_users
2017-01-31	136546
2017-01-30	569070

## Join

### Query

select 
    au.entry_date,
    sum(s.bootups) as bootups, 
    sum(s.sessions) as sessions, 
    sum(s.new_users) as new_users,
    sum(au.counter) as active_users
from 
    active_users as au
join
    (
        select 
            entry_datetime::date as entry_date,
            sum(bootups) as bootups,
            sum(sessions) as sessions,
            sum(new_users) as new_users
        from sessions 
        group by entry_date
    ) as s
    on
        s.entry_date = au.entry_date
group by 
    au.entry_date
order by au.entry_date desc
limit 2

### Result

entry_date	bootups	sessions	new_users	active_users
2017-01-31	1599073124	1597608436	391851288	135351
2017-01-30	5021603350	5017123332	1170441108	569070