Datasette is a great idea. Just wish the SQL parser was more strict. The following produce results which aren't exactly expected:<p><pre><code> select breed, count(*) from [Adelaide-City-Council-dog-registrations-2013]
order by count(*) desc
select breed, count(*) from [Adelaide-City-Council-dog-registrations-2013]
group by breed, order by count(*) desc
</code></pre>
The well formed, unsurprising query is:<p><pre><code> select breed, count(*) from [Adelaide-City-Council-dog-registrations-2013]
group by breed order by count(*) desc</code></pre>