Query how-to

<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>