I have an issue where I’m trying to retrieve the latest Date created row out of a ConCat column. But getting an error that it’s an invalid name. So I’m guessing you can’t do it this way?

Unworking Code:

     SELECT
 [USER ID],
 [GROUP ID],
 [DATE CREATED],
concat([USER ID], '_', [GROUP ID]) as CONCAT
         
  FROM [TABLE1]
     
  where
  [DATE CREATED] in ( SELECT MAX([DATE CREATED]) from [TABLE1] group by CONCAT)`

TABLE
enter image description here

RESULT NEEDED
enter image description here