SQL Query Challenge: Finding the Latest Records

[mercyf]

Maybe try asking ChatGPT. It will probably give a good answer for this.