advent-2021-sql
advent-2021-sql copied to clipboard
Published
20 hours ago •
mitchellh
mitchellh
Advent of Code 2021 using SQL (PostgreSQL-flavored)
Results
2
advent-2021-sql issues
Sort by
recently updated
recently updated
newest added
Well, so, while I had done AoCs before, it has been a few years and I _forgot_ that each problem is two parts. So I actually just straight up forgot...
day1
```SQL WITH RECURSIVE oxygen AS ( SELECT id, value, 1 AS index, (substr(value, 1, 1) = '1') = (sum(substr(value, 1, 1)::int) OVER () >= (count(*) OVER())::FLOAT/2) AS remain FROM day03.inputs...
day03