Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id_event, COUNT(id_event) AS cnt
- FROM bids
- GROUP BY id_event HAVING cnt NOT BETWEEN 0 AND 3;
- SELECT caption, COUNT(b.id_event) AS cnt
- FROM bids b
- join events e on b.id_event=e.id
- GROUP BY e.caption
- HAVING cnt>3;
Add Comment
Please, Sign In to add comment