Group employees by company in query

Question

I’m making a report, where I need to follow the following layout:

With the query below, we ended up creating more lines, instead of grouping employees per company:

select e.cnpj as cnpj,
       e.nome_completo as empresa,
       li.cod as solicitacao,
       ''  funcionarios
       from liberacoes li,
                  empresa    e
             where
                 li.cnpj = e.cnpj and
                 li.dt_acesso_ini = curdate()
union all

select '' as cnpj,
       '' as empresa,
       '' as solicitacao,
       f.nome_completo as funcionario
                                     from funcionarios f,
                                          empresa      e
                                     where
                                         f.cnpj = e.cnpj
                                     order by 1 desc;

Bringing me that result:

In a query only I can make the output layout equal to what I need to follow?

UPDATE

I tried the query below, but the result is still outside of what I need:

  select
       li.cod,
       e.cnpj,
       e.nome_completo as empresa,
       coalesce(f.nome_completo,'X') as funcionario
   from empresa e
   left outer join funcionarios f on f.cnpj = e.cnpj
   left outer join liberacoes li on li.cnpj = e.cnpj

Upshot:

Answer 1

you don’t need Union in this case:

   select distinct
       e.cnpj,
       e.nome_completo as empresa,
       coalesce(f.nome_completo,'X') as funcionario
   from empresa e
   left outer join funcionario f on f.cnpj = e.cnpj