Skip to content

smpetersgithub/AdvancedSQLPuzzles

View on GitHub ↗Related repositories →

Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.

active 2024-01-272026-06-12 (UTC)

Partial coverage17,368 / 22,266 hourly files (78%) · 2 absent upstream · 4,897 failed, retryable2024-01-272026-08-12 (UTC)— sampled evenly across the window, so rankings and trends hold; absolute counts scale up.
Events
609
Pushes
343
Pull requests
0
Issues
2
Stars
222
Forks
37

Activity over time

Daily event counts in the loaded window

Line chart, 868 days from 2024-01-27 to 2026-06-12. Pushes: 343 total, peak 42 in a day. Pull requests: 0 total, peak 0 in a day. Issues: 2 total, peak 1 in a day. Comments: 3 total, peak 1 in a day. Stars: 222 total, peak 4 in a day.

  • Pushes
  • Pull requests
  • Issues
  • Comments
  • Stars

Stars, PRs, issues and forks are under-captured in the later part of this window. GH Archive progressively stopped capturing non-push events during 2026 — −95% or worse by the end of the window. Every series here except Pushes fades for that reason, so a decline above reflects the archive, not this repository. Pushes stay reliable throughout, so read them, and the contributor counts derived from them, as the real signal. Data health has the measurements.

Top contributors

Pushes, PRs, issues, reviews and comments — stars and forks excluded, so this is contribution rather than popularity

ContributorContributionsPushesPRsComments
smpetersgithub34534302
jmadison2222001
Bilbottom1000

Recent activity

Latest issues, pull requests and releases

  • Issue comment#41smpetersgithub2024-07-03 00:30
    Title change and author credit in the Mandelbrot SQL file
  • Issue#41Bilbottom2024-06-29 11:44
    Title change and author credit in the Mandelbrot SQL file
  • Issue comment#38smpetersgithub2024-03-19 02:44
    Convert DDL to Snowflake - Not an issue any more, just some code others might benefit from.
  • Issue comment#38jmadison2222024-03-17 15:37
    Rename columns to remove brackets so Snowflake works better.
  • Issue#38jmadison2222024-03-17 15:26
    Rename columns to remove brackets so Snowflake works better.

Totals cover only the window loaded into ClickHouse and count events, not GitHub's lifetime totals — 222 stars here means stars gained during the window, not the repo's star count.