Optimizing correlated aggregate subqueries in Firebolt. - Andrés Senac; Alexander Alexandrov 001; Immanuel Haffner; Zhen Li; Benjamin Wagner (BTW, 2025)