SELECT COUNT(*), CONCAT(fonok.employee_id, NVL2(fonok.manager_id, ' Alkalmazott', ' Tulajdonos')) FROM nikovits.employees fonok
inner join nikovits.employees beoszt ON beoszt.manager_id = fonok.employee_id
GROUP BY fonok.employee_id, NVL2(fonok.manager_id, ' Alkalmazott', ' Tulajdonos')
ORDER BY COUNT(*) DESC;