Sha256: 6c9fa7295474201d8a99e79a61feac3de35ee98d48d854c57abd861ff5013b8d
Contents?: true
Size: 308 Bytes
Versions: 5
Compression:
Stored size: 308 Bytes
Contents
// vim: ft=javascript
// For each brewery that offers more than 30 beers, the following group-by or
// aggregate query reports the number of beers that it offers
{
"statement": "SELECT br.brewery_id, COUNT(*) AS num_beers FROM beers br GROUP BY br.brewery_id HAVING COUNT(*) > 30 ORDER BY COUNT(*) DESC"
}
Version data entries
5 entries across 5 versions & 2 rubygems