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 github.events 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 github.events 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
ORDER BY avg DESC;
You can’t perform that action at this time.