Q81394 – Tecnologia da Informação – Fundação Getulio Vargas 2022

select pareo, cavalo, tempo from TURFE where not exists (select * from TURFE t where t.pareo = TURFE.pareo and t.tempo < TURFE.tempo)

select pareo, cavalo, tempo from TURFE where exists (select * from TURFE t where t.pareo = TURFE.pareo and t.tempo > TURFE.tempo)

select pareo, cavalo, tempo from TURFE where not exists (select * from TURFE t where t.pareo <> TURFE.pareo and t.tempo = TURFE.tempo)

select pareo, cavalo, tempo from TURFE where exists (select * from TURFE t where t.pareo = TURFE.pareo and t.tempo < TURFE.tempo)

select pareo, cavalo, tempo from TURFE where not exists (select * from TURFE t where t.pareo = TURFE.pareo and t.tempo <> TURFE.tempo)