https://betapython.com/select-rows-with-max-value-partition-by-column/
How Can I SELECT Rows with MAX( Column value), PARTITION by Another Column in MYSQL?