Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select month(postulationdate), count(idpostulant) from postulations
- where postulationdate >= '2014-01-01'
- and idpostulant = (select count(idpostulant) >= 3)
- group by 1
- SELECT month(postulationdate), count(idpostulant)
- FROM postulations
- WHERE postulationdate >= '2014-01-01'
- GROUP BY month(postulationdate)
- HAVING count(idpostulant) >= 3
- SELECT month(postulationdate), count(idpostulant)
- FROM postulations AS a
- WHERE postulationdate >= '2014-01-01'
- AND EXISTS(SELECT idpostulant
- FROM postulations AS b
- WHERE postulationdate >= '2014-01-01'
- AND a.idpostulent = b.idpostulent
- GROUP BY idpostulant
- HAVING count(idpostulant) >= 3)
- GROUP BY month(postulationdate)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement