org.postgresql.util.PSQLException: ERROR: column "hotelroom0_.room" must appear in the GROUP BY clause or be used in an aggregate function code example

Example: postgresql must appear in the group by clause or be used in an aggregate function

Try using "DISTINCT" instead of "GROUP BY"