Count of Ids based on 2 dates in One table

[Anonymous]

Hi

I have 2 dates in my table created date and resolved date, i need to count the keys created by week and resolved by week .. i can do something like this in script and use event type as indicator to filter out resolved and created , but is there any other simplified way to get this done instead of touching existing sql in the application ?

SELECT "create_ts" AS "EventDate",

  "key" AS "key",

'Created' as "EventType"

FROM Table

UNION

SELECT "resolution_date_key",

  "key" AS key",

  'Resolved' as "EventType"

FROM Table

Thanks

[Gysbert_Wassenaar]

This looks like the right approach to me. I don't see a simpler way that won't complicate other things.