I found a weird issue on aurora mysql 8 3.02.1 where you get zero values for the column if you filter them from a derived table with no group by.
Removing the filter for the column would show the correct value. If theres multiple columns being filtered removing one would show the value for the removed filter but the other column is still zero.
Adding group by inside the derived table would display correct values.
Is this a mysql 8 changes or a bug?