| SELECT
d,
sum(c>5) yli5,
sum(c>99) yli100,
sum(c>199) yli200,
... |
1 year ago |
| SELECT
d,
sum(c>99) yli100,
sum(c>199) yli200,
sum(c>499)... |
1 year ago |
| SELECT
d,
sum(c>99) 100+,
sum(c>199) 200+,
sum(c>499) 500+,
... |
1 year ago |
| SELECT
d,
sum(1) as total,
sum(c>99) 100m,
sum(c>199) 200m,
... |
1 year ago |
| SELECT
d,
sum(1) as total,
sum(c>99) 100m,
sum(c>199) 200m,
... |
1 year ago |
| SELECT
d,
sum(1) as total,
sum(c>99) 100plus,
sum(c>199)... |
1 year ago |
| SELECT
d,
sum(1) as total,
sum(c>99) 100plus,
sum(c>199)... |
1 year ago |
| SELECT
floor(rev_timestamp/100000000) AS d,
rev_user, SUM(1) AS c... |
1 year ago |
| SELECT
floor(rev_timestamp/100000000) AS d,
rev_user, SUM(1) AS c... |
1 year ago |
