Considerando os algoritmos acima, em que são criadas as tabelas predio e salas, assinale a opção cuja expressão SQL apresenta informações do registro da maior sala existente.
- A select c1.local, c1.nome, c2.descricao, c2.area
from predio as c1, salas as c2
where c2.local=c1.mnemonico
having max(c2.area) - B select c1.local, c1.nome, c2.descricao, max(c2.area)
from predio as c1, salas as c2
where c2.local=c1.id
group by c1.local, c1.nome, c2.descricao - C select c1.local, c1.nome, c2.descricao
from predio as c1,
(
select local, descricao, area from salas as c1
where area = (select max(area) from salas as
c2 where area>0)
) as c2 where c2.local=c1.mnemonico; - D select c1.local, c1.nome, c2.descricao, c2.area
from predio as c1,
(
select local, descricao, area from salas as c1
where area = (select max(area) from salas as
c2 where area>0)
) as c2 where c2.id=c1.codigo; - E select c1.local, c1.nome, c2.descricao, max(c2.area)
from predio as c1 join salas as c2
on c2.codigo=c1.id
group by c1.local, c1.nome, c2.descricao