First Paid Users

The number of people who first paid the money to the product.

Description

The number of people who first paid the money to the product. This is used to measure the overall trends of new paid users.

Sample Input

pay
time user_id price count
1416435585 2 100 3
1416435586 3 500 1
1416435587 5 100 10
1416435588 1 100 8
... ... ... ...

Query


to view this query

Sample Output

day first_paid_users
2014-10-01 321
2014-10-02 364
2014-10-03 343
2014-10-04 321
2014-10-05 401
2014-10-06 321
2014-10-07 321
2014-10-08 364
2014-10-09 343
2014-10-10 321
2014-10-11 321
2014-10-12 364
2014-10-13 343
2014-10-14 321