By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
@sql := group_concat(distinct 'sum(case when event_type = ''', event_type, ''' then number else 0 end)/sum(number) as `ratio_', event_type, '`' ) |
---|
sum(case when event_type = 'exampleG1' then number else 0 end)/sum(number) as `ratio_exampleG1`,sum(case when event_type = 'exampleG2' then number else 0 end)/sum(number) as `ratio_exampleG2`,sum(case when event_type = 'exampleG3' then number else 0 end)/sum(number) as `ratio_exampleG3` |
@sql |
---|
select date(created_at) date_bucket, sum(case when event_type = 'exampleG1' then number else 0 end)/sum(number) as `ratio_exampleG1`,sum(case when event_type = 'exampleG2' then number else 0 end)/sum(number) as `ratio_exampleG2`,sum(case when event_type = 'exampleG3' then number else 0 end)/sum(number) as `ratio_exampleG3` from example_table group by date(created_at) order by date_bucket |
date_bucket | ratio_exampleG1 | ratio_exampleG2 | ratio_exampleG3 |
---|---|---|---|
2020-06-02 | 0.1429 | 0.2857 | 0.5714 |
2020-06-03 | 1.0000 | 0.0000 | 0.0000 |