I have a table which contains the places where different people have been, I'm trying to get the last place where each of those people was in a single table, for this I'm grouping by IdEmployed and looking for the major date, those two If I get the data correctly, the problem is that the other columns do not correspond to the ones I'm trying to obtain. I leave images of my table and my query. I hope you can help me, thank you very much.
