Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT osetrovatele.jmeno, zvirata.jmeno, DATEDIFF(CURRENT_DATE, osetrovatele.narozen) / 365 AS clovekNarozeni, zvirata.vaha AS zvirataVaha
- FROM osetrovatele JOIN osetruje on (osetrovatele.id = osetruje.osetrovatel) JOIN zvirata ON (osetruje.zvire = zvirata.id)
- GROUP BY osetrovatele.jmeno
- HAVING zvirataVaha > clovekNarozeni
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement