Not a valid GROUP BY expression

Get Help
1

Can someone please help to group by Email field? Thank you

note: if i don't group, it works without min and max function.

SELECT SERVICES.SHIFTS.EMAIL AS EMAIL, min(SERVICES.SHIFTS.START_TIME) AS START_TIME, max(SERVICES.SHIFTS.END_TIME) AS END_TIME
FROM SERVICES.SHIFTS
WHERE (
        SERVICES.SHIFTS.SHIFT_NAME = 'BackOffice' AND
        CAST(min(SERVICES.SHIFTS.START_TIME ) AS timestamp) <= CAST(now() AS timestamp) AND
        CAST(max(SERVICES.SHIFTS.END_TIME) AS timestamp) > CAST(now() AS timestamp) AND
        SERVICES.SHIFTS.IS_PAID= TRUE
        )
GROUP BY SERVICES.SHIFTS.EMAIL
ORDER BY SERVICES.SHIFTS.START_TIME ASC
2

just asked chatgpt and returned the following:

SELECT SERVICES.SHIFTS.EMAIL AS EMAIL, 
       MIN(SERVICES.SHIFTS.START_TIME) AS START_TIME, 
       MAX(SERVICES.SHIFTS.END_TIME) AS END_TIME
FROM SERVICES.SHIFTS
WHERE SERVICES.SHIFTS.SHIFT_NAME = 'BackOffice' 
  AND CAST(MIN(SERVICES.SHIFTS.START_TIME) AS timestamp) <= CAST(NOW() AS timestamp) 
  AND CAST(MAX(SERVICES.SHIFTS.END_TIME) AS timestamp) > CAST(NOW() AS timestamp) 
  AND SERVICES.SHIFTS.IS_PAID = TRUE
GROUP BY SERVICES.SHIFTS.EMAIL
ORDER BY MIN(SERVICES.SHIFTS.START_TIME) ASC