A select c1.local, c1.nome, c2.descricao, c2.areafrom predio as c1, salas as c2where c2.local=c1.mnemonicohaving max(c2.area)
B select c1.local, c1.nome, c2.descricao, max(c2.area)from predio as c1, salas as c2where c2.local=c1.idgroup by c1.local, c1.nome, c2.descricao
C select c1.local, c1.nome, c2.descricaofrom predio as c1,(select local, descricao, area from salas as c1where area = (select max(area) from salas asc2 where area>0)) as c2 where c2.local=c1.mnemonico;
D select c1.local, c1.nome, c2.descricao, c2.areafrom predio as c1,(select local, descricao, area from salas as c1where area = (select max(area) from salas asc2 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 c2on c2.codigo=c1.idgroup by c1.local, c1.nome, c2.descricao