Questão número 292314
- A.
select x4, sum(x5)
from X, Y
where x1 = y2
and x2 = y3
and y1 between 100 and 500
group by x4;
- B.
select x4, sum(x5)
from X, Y
where y1 = x1
and y2 = x2
and y1 between 100 and 500
- C.
select x4, count(x5)
from X, Y
where x1 = y1
and x2 = y2
and y1 >= 100
and y1 <= 500
group by x4;
- D.
select x4, count(*)
from X, Y
where y2 = x1
and y3 = x2
and y1 between 101 and 501;
O Provas e Concursos é um banco de dados de questões de concursos públicos organizadas por matéria, assunto, ano, banca organizadora, etc
