-- Which GuestIDs have made more than 2 bookings?
where 'count(bookingid)' < 2
group by guestid
it just shows all the count not the ones obove 2
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.