Guest User

Untitled

a guest
Jul 18th, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. SELECT id_event, COUNT(id_event) AS cnt
  2. FROM bids
  3. GROUP BY id_event HAVING cnt NOT BETWEEN 0 AND 3;
  4.  
  5. SELECT caption, COUNT(b.id_event) AS cnt
  6. FROM bids b
  7. join events e on b.id_event=e.id
  8. GROUP BY e.caption
  9. HAVING cnt>3;
Add Comment
Please, Sign In to add comment