MAU (Monthly Active Users)

The monthly number of users who have accessed to the game.

Description

Monthly active users (MAU) is one of the ways used for measuring success of games. MAU measures "stickiness" of an online product – how many unique users visit the site daily? Usually the only requirement for a user to be considered "active" is that they somehow view or access with the product. The daily aggregate of DAU is monthly active users (DAU).

Sample Input

access
time user_id
1416435585 2
1416435586 3
1416435587 5
1416435588 1
... ...

Query


to view this query

Sample Output

d uu
2014-01 321
2014-02 364
2014-03 343
2014-04 321
2014-05 401
2014-06 321
2014-07 321
2014-08 364
2014-09 343
2014-10 321
2014-11 321
2014-12 364