Hi,
I was wondering if you can help me with the following query.
Given table T1 and columns id, start_date, stop_date and status, propose a
query that reports count of items opened and closed . status is an enum
including NEW, xxx, xxxx, CLOSED. The first status of an item is NEW (could
be used in place of start_date)
For example
Date Opened Closed
=============================
yyyy-mm-dd 25 6
yyyy-mm-dd 0 16
yyyy-mm-dd 12 0
etc
etc
Thanks
Medi