Tyron Aling Tyron Aling - 7 months ago 19
SQL Question

How to use count() in condition

Which GuestIDs have made more than 2 bookings?

I have query:

select guestid,count(BookingID)
from bookings
where 'count(bookingid)' < 2
group by guestid


it just shows all the count not the ones obove 2
plz help

Answer

Try:

 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.

Comments