Skip to content

Instantly share code, notes, and snippets.

@mustafaakin

mustafaakin/query2.sql

Created February 27, 2018 10:37
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 mustafaakin/146814ddb4bcd56cdea51e48c58d12d4 to your computer and use it in GitHub Desktop.
Save mustafaakin/146814ddb4bcd56cdea51e48c58d12d4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query2.sql
SELECT sourceaddress,
destinationaddress,
SUM(bytes) AS totalBytes
FROM flows
GROUP BY sourceaddress, destinationaddress
ORDER BY totalBytes DESC LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment