Skip to content

Instantly share code, notes, and snippets.

@ahachete

ahachete/Stampede-GithuQuery-PostgreSQL-D

Created November 30, 2016 11:44
Show Gist options
  • Save ahachete/c9c76b84ddec69febf7f63c4264fb14d to your computer and use it in GitHub Desktop.
Save ahachete/c9c76b84ddec69febf7f63c4264fb14d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Stampede-GithuQuery-PostgreSQL-D
SELECT action_s, count(*)
FROM github.events_payload
WHERE action_s IS NOT NULL
GROUP BY action_s
ORDER BY count DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment