Advertisement
Guest User

Untitled

a guest
Oct 17th, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.32 KB | None | 0 0
  1. SELECT osetrovatele.jmeno, zvirata.jmeno, DATEDIFF(CURRENT_DATE, osetrovatele.narozen) / 365  AS clovekNarozeni, zvirata.vaha AS zvirataVaha
  2. FROM osetrovatele JOIN osetruje on (osetrovatele.id = osetruje.osetrovatel) JOIN zvirata ON (osetruje.zvire = zvirata.id)
  3. GROUP BY osetrovatele.jmeno
  4. HAVING zvirataVaha > clovekNarozeni
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement