1 - select nome,count(cpf)
 from leiloeiro l, bem b, oferta_rel o
 where o.id_bem = b.id_bem
 and o.cpf_leiloeiro = l.cpf
 having count(cpf) >= ALL (select count(cpf)
      from leiloeiro l, bem b, oferta_rel o
      where o.id_bem = b.id_bem
      and o.cpf_leiloeiro = l.cpf
      group by cpf) 
 group by cpf


2 - select o.id_bem from leiloeiro l, oferta_rel o where o.cpf_leiloeiro = l.cpf and l.nome = 'Romero';

3 - select a.nome 
 from arrematante a, oferta_ent o
 where o.cpf_arrematante = a.cpf
 and o.preco >= ALL (select preco 
                     from oferta_ent)

4 - select o.id_bem from oferta_ent o;


5 - select a.nome, count(p.pessoa2)
 	from patrocina p, arrematante a
 	where a.cpf = p.pessoa2 
 	group by nome 
 	having count(p.pessoa2) >=  ALL (select count(pessoa2) from
	patrocina group by pessoa2);

6- select o.id_bem from oferta_ent o where o.qtd_lances >= ALL(select qtd_lances from oferta_ent);

7 - select l.num, min(l.data)
	from leilao l
	group by l.num ;

 
8 - select a.nome 
    from arrematante a, oferta_ent o 
    where a.cpf = o.cpf_arrematante and o.preco > 70000 group by nome; 

9 - select distinct l.num, p.nome 
	from leiloeiro p, leilao l, oferta_rel o 
	where p.cpf = o.cpf_leiloeiro and l.num = o.num and o.id_bem = 1 ;

10 - select AVG(o.preco) as Media from oferta_ent o;