https://mingredbestcheapprice.blogspot.com/2024/03/how-to-perform-groupby-and-transform.html