Advertisement
Guest User

Untitled

a guest
Dec 18th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. select
  2. (case when checkintime BETWEEN '2017-08-01 00:00:00' AND '2017-08-31 23:59:00' THEN 'August'
  3. when checkintime BETWEEN '2017-09-01 00:00:00' AND '2017-09-30 23:59:00' THEN 'September'
  4. when checkintime BETWEEN '2017-10-01 00:00:00' AND '2017-10-31 23:59:00' THEN 'October'
  5. when checkintime BETWEEN '2017-11-01 00:00:00' AND '2017-08-31 23:59:00' THEN 'November'
  6. else 'other') end
  7. AS period, SUM(amount)/50 AS 'Regus Net Revenue'
  8.  
  9.  
  10.  
  11. from
  12. tblTransactions
  13.  
  14.  
  15. where
  16. garage_id IN ('141', '135', '136')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement