AggregateColumns must not be null or empty

I'm trying to do create the below statement in a Query Entity. (see attached)

"select int_field, text_field from table_name where date_field = (select MAX(date_field) from table_name where id = id)"

I think I'm missing something as it's complaining about aggregatecolumns must not be null or empty.

query entity.txt

OriginalPostID-228561

OriginalPostID-228561