Revenue per Product Category

The revenue generated, per product category

Description

By looking at the trend of revenue distribution per product category, you can see what kind of product is making more or less revenue over time.

Sample Input

pay
time user_id category price count
1416435585 2 category2 100 3
1416435586 3 category6 500 1
1416435587 5 category8 100 10
1416435588 1 category7 100 8
... ... ... ... ...

Query


to view this query

Sample Output

month category sum
2014-10 category0 40400
2014-11 category0 40200
2014-12 category0 35100
2014-10 category1 20500
2014-11 category1 18100
2014-12 category1 90800
2014-10 category2 43700
2014-11 category2 11700
2014-12 category2 53800
2014-10 category3 83500
2014-11 category3 93800
2014-12 category3 88500
2014-10 category4 23700
2014-11 category4 31400
2014-12 category4 50500
2014-10 category5 21900
2014-11 category5 92000
2014-12 category5 36500
2014-10 category6 19800
2014-11 category6 33300
2014-12 category6 32600
2014-10 category7 59200
2014-11 category7 40400
2014-12 category7 12600
2014-10 category8 65500
2014-11 category8 10300
2014-12 category8 45400
2014-10 category9 93200
2014-11 category9 1100
2014-12 category9 2500