1
edit
Changes
no edit summary
<td>select count(*) from bugs where product_id=46;</td>
<td>27</td>
</tr>
<tr>
<th>How many bugs are currently NEW vs. ASSIGNED vs. RESOLVED, etc.</th>
</tr>
<tr>
<td>New</td>
<td>select count(*) from bugs where bug_status='NEW';</td>
<td>44,568</td>
</tr>
<tr>
<td>Assigned</td>
<td>select count(*) from bugs where bug_status='ASSIGNED';</td>
<td>4,697</td>
</tr>
<tr>
<td>Resolved</td>
<td>select count(*) from bugs where bug_status='RESOLVED';</td>
<td>207,496</td>
</tr>
<tr>
<td>Verified</td>
<td>select count(*) from bugs where bug_status='VERIFIED';</td>
<td>148,747</td>
</tr>
<tr>
<td>Closed</td>
<td>select count(*) from bugs where bug_status='CLOSED';</td>
<td>1,496</td>
</tr>
<tr>
<td>Reopened</td>
<td>select count(*) from bugs where bug_status=REOPENED';</td>
<td>962</td>
</tr>
<tr>
<td>Unconfirmed</td>
<td>select count(*) from bugs where bug_status='UNCONFIRMED';</td>
<td>18,026</td>
</tr>
</table>