Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- (case when checkintime BETWEEN '2017-08-01 00:00:00' AND '2017-08-31 23:59:00' THEN 'August'
- when checkintime BETWEEN '2017-09-01 00:00:00' AND '2017-09-30 23:59:00' THEN 'September'
- when checkintime BETWEEN '2017-10-01 00:00:00' AND '2017-10-31 23:59:00' THEN 'October'
- when checkintime BETWEEN '2017-11-01 00:00:00' AND '2017-08-31 23:59:00' THEN 'November'
- else 'other') end
- AS period, SUM(amount)/50 AS 'Regus Net Revenue'
- from
- tblTransactions
- where
- garage_id IN ('141', '135', '136')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement