OILS / regtest / aports / summary.sql View on Github | oils.pub

18 lines, 15 significant
1-- Disagreements
2
3select '<table id="summary-table">';
4
5select
6 printf(
7 '<tr> <td>Notable Disagreements:</td> <td class="num"><b>%d</b></td> </tr>',
8 count(*)
9 )
10from notable_disagree;
11select
12 printf(
13 '<tr> <td>Elapsed Hours:</td> <td class="num"><b>%.1f</b></td> </tr>',
14 sum(elapsed_minutes) / 60
15 )
16from metrics;
17
18select '</table>';