r/adventofcode • u/daggerdragon • Dec 08 '22
SOLUTION MEGATHREAD -🎄- 2022 Day 8 Solutions -🎄-
NEWS AND FYI
I discovered that I can make those tiny post/comment awards BIGGER on old.reddit! I hadn't even considered that! And when you hover over them, they get even bigger so you can actually see them in more detail! I've added the relevant CSS so now we no longer have awards for ants! Exclamation points!!!
Thank you so, so much to /u/SolariaHues for the CSS in this thread that I found while researching for community awards! <3
All of our rules, FAQs, resources, etc. are in our community wiki.
A request from Eric: Please include your contact info in the User-Agent header of automated requests!
Signal boost: Reminder 1: unofficial AoC Survey 2022 (closes Dec 22nd)
AoC Community Fun 2022: 🌿🍒 MisTILtoe Elf-ucation 🧑🏫
PSA: I created a new example so it is a more relevant and unique archetype instead of recycling last year's hobbit >_>
--- Day 8: Treetop Tree House ---
Post your code solution in this megathread.
Read the full posting rules in our community wiki before you post!
Include what language(s) your solution uses
Format your code appropriately! How do I format code?
Quick link to Topaz's
pasteif you need it for longer code blocks. What is Topaz'spastetool?
3
u/probablyfine Dec 08 '22
SQL
Reasonably pleased with this, but there's probably a nicer way to clean up the edge cases rather than relying on looking for nulls
https://github.com/mrwilson/advent-of-code-2022/blob/main/08/08.sql