Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as SQL by oi ( 11 years ago )
select distinct count(a.id)
from plano_voo pv
 inner join aviao a
  on pv.id_aviao=a.id
 inner join rota r
  on pv.id_rota=r.id
  and r.destino='Aeroporto Internacional John F. Kennedy'
 inner join voo v
  on v.id=pv.id_voo
  and v.max_velocidade between 200 adn 300;

 

Revise this Paste

Your Name: Code Language: