Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ---it returns average values aggregated by day, week, month and year for %HRT%
- select * from
- (
- select 'day', kpi_id, avg(value) from kpis
- where kpi_id like '%HRT%'
- and interval_type='day'
- group by kpi_id
- union
- select 'week', kpi_id, avg(value) from kpis
- where kpi_id like '%HRT%'
- and interval_type='week'
- group by kpi_id
- union
- select 'month', kpi_id, avg(value) from kpis
- where kpi_id like '%HRT%'
- and interval_type='month'
- group by kpi_id
- union
- select 'year', kpi_id, avg(value) from kpis
- where kpi_id like '%HRT%'
- and interval_type='year'
- group by kpi_id
- ) as k
- order by kpi_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement