D 1 SELECT 2 count (case 3 when hr = 2 and vehiclescash > 400 then 1 4 else 0 5 end) as ct1 6 count (case } 7 when hr = 2 and vehiclescash < 5 then 1 8 else 0 9 end) as ct2 10 FROM cls.mta 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 line 12, column 1, location 178 ct1 ct2 1165728 1165728 31 line 14, column 2, location 189 ct1 ct2 256 1465