Which GuestIDs have made more than 2 bookings?
I have query:
where 'count(bookingid)' < 2
group by guestid
select guestId, count(bookingId) as booking_count from bookings group by guestId having count(bookingID) > 2
To apply conditions to aggregate values, you need to use the having clause. Also, you specified the comparison as "<" rather than ">". This could clearly cause confusion.