'Got Max Value Correct But Date Corresponding to this is wrong

I need your guidance. I have a table in this table I have 3 columns

ID, Date, Forums

The issue i am facing

I got Id correct,Max(forum) correct but the date against id and max forum is wrong .

In short i want to say Id 221 fill 170 forms in 30-07-2021 but the date i got is wrong please check below image enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source