seems like there’s an issue with case 3. the person_id and from surveillance_records doesn’t match up with the person_id in the hotel_checkins table when joined on hotel-checkin_id

haaave you heard about our lord and saviour Typst?

same layout algorithm as LaTeX, but:

• simpler markup
• sane, consistent scripting language
• fast compilation, including incremental updates so you can have a process watching your file and instantly create a new PDF on changes
• easy collaborative editing through their web app
• actually understandable error messages

To be a positive impact, they just need to be less carbon intensive thans the energy they displace. According to the first results on google, (presumably utility-scale) solar is about 12 times less carbon intensive than natural gas and 20 times compared to coal. So as long as you’re replacing base load and not utility solar, balcony solar could be as much as 10 times less efficient and still come out a net positive.

Keep in mind also that these numbers keep improving as solar panel manufacturing becomes more efficient and starts using more green energy itself over the coming decades