AOC2021-postgresql

Let's see how far this can go ...

All input is assumed to be already ingested in a table like:

CREATE TABLE aoc."2021_day_01" (
    id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    data text
);

Name		Name	Last commit message	Last commit date
Latest commit History 20 Commits
LICENSE		LICENSE
README.md		README.md
day_01_1.sql		day_01_1.sql
day_01_2.sql		day_01_2.sql
day_02_1.sql		day_02_1.sql
day_02_2.sql		day_02_2.sql
day_03_1.sql		day_03_1.sql
day_03_2.sql		day_03_2.sql
day_04_1.sql		day_04_1.sql
day_04_2.sql		day_04_2.sql
day_05_1.sql		day_05_1.sql
day_05_2.sql		day_05_2.sql
day_06_1.sql		day_06_1.sql
day_06_2.sql		day_06_2.sql
day_07_1.sql		day_07_1.sql
day_07_2.sql		day_07_2.sql
day_08_1.sql		day_08_1.sql
day_08_2.sql		day_08_2.sql
day_09_1.sql		day_09_1.sql
day_09_2.sql		day_09_2.sql
day_10_1.sql		day_10_1.sql
day_10_2.sql		day_10_2.sql

Provide feedback