Advertisement
Dario_torregrossa

HRT investigation

Apr 24th, 2014
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. ---it returns average values aggregated by day, week, month and year for %HRT%
  2.  
  3.  
  4. select * from
  5. (
  6.  
  7. select 'day', kpi_id, avg(value) from kpis
  8. where kpi_id like '%HRT%'
  9. and interval_type='day'
  10. group by kpi_id
  11.  
  12. union
  13.  
  14. select 'week', kpi_id, avg(value) from kpis
  15. where kpi_id like '%HRT%'
  16. and interval_type='week'
  17. group by kpi_id
  18.  
  19. union
  20.  
  21. select 'month', kpi_id, avg(value) from kpis
  22. where kpi_id like '%HRT%'
  23. and interval_type='month'
  24. group by kpi_id
  25.  
  26. union
  27.  
  28. select 'year', kpi_id, avg(value) from kpis
  29. where kpi_id like '%HRT%'
  30. and interval_type='year'
  31. group by kpi_id
  32.  
  33. ) as k
  34.  
  35. order by kpi_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement