# of Days from Register to First Payment

The distribution of how many days it took from the registration to first payment.

Description

The distribution of how many days it took from the registration to first payment.

Sample Input

register
time user_id
1416435585 2
1416435586 3
1416435587 5
1416435588 1
... ...
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