SQL isn't the most portable language. Postgres has special behavior for aggregates/having without group by which essentially creates an implicit group by, other engines will raise an error (SQL Server iirc)
Clearly not something to nitpick over in an interview
Clearly not something to nitpick over in an interview