Skip to content

Instantly share code, notes, and snippets.

Álvaro Hernández Tortosa ahachete

Block or report user

Report or block ahachete

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View Stampede-GithuQuery-PostgreSQL-E
WITH distinct_commits AS (
SELECT DISTINCT repo.name_s, actor.login_s
FROM AS events
INNER JOIN github.events_actor AS actor ON (events.did = actor.did)
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
WHERE events.type_s = 'PushEvent'
SELECT name_s, count(*)
FROM distinct_commits
GROUP BY name_s
View Stampede-GithuQuery-PostgreSQL-F
SELECT repo.name_s, avg(payload.size_i)
FROM AS events
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
WHERE events.type_s = 'PushEvent' AND payload.size_i > 2
GROUP BY repo.name_s
You can’t perform that action at this time.