Skip to content

Instantly share code, notes, and snippets.

@mustafaakin

mustafaakin/query3.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/33d099dd04a8c0ddb41c7a3296c40c78 to your computer and use it in GitHub Desktop.
Save mustafaakin/33d099dd04a8c0ddb41c7a3296c40c78 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query3.sql
SELECT destinationport,
COUNT(*) AS total
FROM flows
WHERE action = ‘REJECT’
GROUP BY destinationport
ORDER BY total DESC LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment