Difference between revisions of "Bugzilla Analysis"
| Line 1: | Line 1: | ||
Students in BTR490 are working on analyzing historical Bugzilla data for Mozilla. This pages documents some of their findings and ideas. | 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> | ||
Revision as of 23:08, 25 June 2008
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
| Questions | Query | Result |
|---|---|---|
| How many bugs are there? | Select count(bug_id) from bugs; | 425,992 |
| How many bugs per year? | ||
| 1994 | Select count(distinct bug_id) from bugs where creation_ts like '1994%'; | 2 |
