sorry about the subject but i'm not quite sure what is that i'm
asking...

i'm rewriting our internal helpdesk and there's a report that i need
to produce to show a summary of calls between particular dates, namely
the date, the number of calls logged on that date and the number of
calls resolved on that date. so it looks basically like this...

Date Logged Resolved
----------------------------------------
21/02/2005 23 22
...

i know i can select all calls thusly

SELECT COUNT(*), CAST("Date_Time" AS DATE)
FROM CALLS
//where date between...just testing all calls atm
GROUP BY 2
ORDER BY 2

is there any way of counting the number of resolved calls (theres a
"Resolved" column for each call record) in the same query?

running firebird 1.5.2.4731

TIA