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