1
edit
Changes
no edit summary
Students in BTR490 are working on analyzing historical Bugzilla data for Mozilla. This pages documents some of their findings and ideas.
== Bugzilla Database Questions ==
By:Timothy Kwan, Rajiv Gagwani, Jasdeep Singh Goraya
----
<table class="standard-table" border=1>
<tr>
<th>Questions</th>
<th>Query</th>
<th>Result</th>
</tr>
<tr>
<td>How many bugs are there?</td>
<td>Select count(bug_id) from bugs;</td>
<td>425,992</td>
</tr>
<tr>
<td>How many bugs per year?</td>
</tr>
<tr>
<td>1994</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td>
<th>2</th>
</table>
