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 bombom ( 11 years ago )
select p.condicoes as qtdPistas, p.id 
from pista p
where p.comprimento > 
 (select avg(comprimento)
 from pista)
group by p.condicoes;

 

Revise this Paste

Parent: 78387
Your Name: Code Language: