Skip to content

Instantly share code, notes, and snippets.

@glynnbird

glynnbird/block5a.sh

Created November 8, 2018 12:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save glynnbird/6349f34a21407815830693f44d6a5f19 to your computer and use it in GitHub Desktop.
Save glynnbird/6349f34a21407815830693f44d6a5f19 to your computer and use it in GitHub Desktop.
Download ZIP
block5a.sh
Raw
block5a.sh
sqlite> SELECT dispatchAddress_town as town, SUM(total)
FROM mystore
GROUP BY 1
ORDER BY 2
DESC LIMIT 10;
town SUM(total)
---------- ----------
Newport 41067.81
Linlithgow 27923.21
North Berw 27328.37
Musselburg 24245.96
Dorchester 23587.35
Alton 22734.98
Swinton 22283.56
Westgate o 21819.46
Beaminster 21202.51
Audenshaw 20864.46
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment