SELECT c.nome, COUNT(f.cpf) FROM CARGO c

LEFT JOIN FUNCIONARIO f ON c.codigo = f.cargo

GROUP BY c.nome

SELECT c.nome, COUNT(*) FROM CARGO c

LEFT JOIN FUNCIONARIO f ON c.codigo = f.cpf

GROUP BY c.nome

SELECT c.nome, COUNT(*) FROM CARGO c

INNER JOIN FUNCIONARIO f ON c.codigo = f.cargo

GROUP BY c.nome

SELECT c.nome, COUNT(*) FROM CARGO c

RIGHT JOIN FUNCIONARIO f ON c.codigo = f.cargo

GROUP BY c.nome