beowulf1416

Untitled

Oct 6th, 2015
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT
  2. rtmbha.report_date,
  3. rtmbha.report_hours,
  4. sum(rtmbha.total_minutes),
  5. sum(rtmbha.phone_minutes),
  6. sum(rtmbha.widget_minutes)
  7. from report_total_minutes_by_hour_actual rtmbha
  8. WHERE (
  9. created_at > '2015-10-05 00:00:00 -0400'
  10. and created_at < '2015-10-05 23:59:59 -0400'
  11. )
  12. GROUP BY report_hours
Advertisement
Add Comment
Please, Sign In to add comment