Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- a)
- SELECT AVION.IDAVION, VUELO.IDFECHA
- FROM AVION, VUELO, COMPANIA
- WHERE (COMPANIA.IDCIA=AVION.IDCIA) AND (COMPANIA.NCIA='AIR') AND (VUELO.IDCIA=COMPANIA.IDCIA)
- GROUP BY AVION.IDAVION
- HAVING MIN(VUELO.IDFECHA)
- ORDER BY 2 DESC
- b)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement