PL/SQL return count for all dates

[zaffer]

SELECT trunc(sysdate) dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate) = trunc(create_time)
union
SELECT trunc(sysdate)-1 dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate)-1 = trunc(create_time)
union
SELECT trunc(sysdate)-2 dt, count(*) as count
FROM ATM_MONITOR.ATM_PROBLEM
WHERE trunc(sysdate)-2 = trunc(create_time)

It returns
DT COUNT
--------------------------
19.10.2011 741
18.10.2011 498
17.10.2011 918


How can I get this code in one statment???

[Rabbit]

I'm surprised that it runs in the first place unless PL/SQL doesn't require the group by clause.

You can just use the BETWEEN operator to combine your filter clauses. And bring in the create_time as opposed to the sysdate in your SELECT clause.

[irfanEmmaneul]

the code can be created in expression