SELECT  COUNT(CT.cumTxnReportId),CT.cumTxnReportId,CT.ticketNum ,DATE_FORMAT(CT.exitDateTimeUtc,'%m-%Y'),
sum(netAmount) As total_revenue,D.name,HOUR(CT.entranceDateTimeUtc) as entryHour,
HOUR(CT.exitDateTimeUtc) as exitHour,CT.entranceDateTimeUtc,CT.exitDateTimeUtc,CT.netAmount AS netAmount,
CT.grossAmount,CT.discountAmount,CT.rate,CT.txnType,CT.ticketType,CT.txnNum,CT.numDiscounts
FROM Parkloco.ParkingArea PA JOIN IParcPro.Device D ON PA.id = D.parkingAreaId
JOIN Parkloco.RateCard RC ON PA.id = RC.parkingAreaId  JOIN IParcPro.CumTxn CT ON D.id = CT.deviceId
WHERE PA.uuid = '27d842c1-7057-11e6-a0eb-1245b0d35d23'
AND (   CT.txnType = 'Allowed' OR CT.txnType = 'Add' OR CT.txnType = 'Normal' OR CT.txnType = 'Offline' OR CT.txnType = 'Repay')
AND ((CT.entranceDateTimeUtc >= '2016-08-01 00:00:00' AND CT.exitDateTimeUtc <= '2017-04-31 23:59:59'))
AND (   RC.state = 'active' OR RC.state = 'archived') AND RC.fromDateTimeUtc <= '2017-04-31 23:59:59'
AND (   RC.thruDateTimeUtc IS NULL OR RC.thruDateTimeUtc >= '2016-08-01 00:00:00')
AND (   TIMESTAMPDIFF (SECOND, CT.entranceDateTimeUtc, CT.exitDateTimeUtc) >= '0' * 60)
AND (   TIMESTAMPDIFF (SECOND, CT.entranceDateTimeUtc, CT.exitDateTimeUtc) < '1441' * 60)
AND CT.numDiscounts=0 AND CT.ticketNum !=0 GROUP BY DATE_FORMAT(CT.exitDateTimeUtc,'%m-%Y')

SELECT  COUNT(CT.cumTxnReportId),CT.cumTxnReportId,CT.ticketNum ,DATE_FORMAT(CT.exitDateTimeUtc,'%m-%Y'),
sum(netAmount) As total_revenue,D.name,HOUR(CT.entranceDateTimeUtc) as entryHour,
HOUR(CT.exitDateTimeUtc) as exitHour,CT.entranceDateTimeUtc,CT.exitDateTimeUtc,CT.netAmount AS netAmount,
CT.grossAmount,CT.discountAmount,CT.rate,CT.txnType,CT.ticketType,CT.txnNum,CT.numDiscounts
FROM Parkloco.ParkingArea PA JOIN IParcPro.Device D ON PA.id = D.parkingAreaId
JOIN Parkloco.RateCard RC ON PA.id = RC.parkingAreaId  JOIN IParcPro.CumTxn CT ON D.id = CT.deviceId
WHERE PA.uuid = '27d842c1-7057-11e6-a0eb-1245b0d35d23'
AND (   CT.txnType = 'Allowed' OR CT.txnType = 'Add' OR CT.txnType = 'Normal' OR CT.txnType = 'Offline' OR CT.txnType = 'Repay')
AND ((CT.entranceDateTimeUtc >= '2016-08-01 00:00:00' AND CT.exitDateTimeUtc <= '2017-07-31 23:59:59'))
AND (   RC.state = 'active' OR RC.state = 'archived') AND RC.fromDateTimeUtc <= '2017-07-31 23:59:59'
AND (   RC.thruDateTimeUtc IS NULL OR RC.thruDateTimeUtc >= '2016-08-01 00:00:00')
AND (   TIMESTAMPDIFF (SECOND, CT.entranceDateTimeUtc, CT.exitDateTimeUtc) >= '0' * 60)
AND (   TIMESTAMPDIFF (SECOND, CT.entranceDateTimeUtc, CT.exitDateTimeUtc) < '1441' * 60)
AND CT.numDiscounts=0 AND CT.ticketNum !=0 GROUP BY DATE_FORMAT(CT.exitDateTimeUtc,'%m-%Y')