Hey Leihua. Thanks for a really great post. It's super helpful to see these problems outlined.

Two quick notes. In solution 5, the GROUP BY and DISTINCT are redundant - I'd choose one or the other. In solution 3, I think you have to convert one of the cols to a float - the current solution would take the integer average then round it.

Thanks again for making this content!