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