---

SELECT
    s.id_sotrudnik AS 'ID сотрудника',
    s.familiya AS 'Фамилия',
    s.imya AS 'Имя',
    s.otchestvo AS 'Отчество',
    d.dolzhnost AS 'Должность',
    COUNT(dg.id_dogovor) AS 'Количество договоров'
FROM sotrudnik s
JOIN dolzhnost d ON s.dolzhnost = d.id_dolzhnost
LEFT JOIN dogovor dg ON s.id_sotrudnik = dg.id_sotrudnik
GROUP BY
    s.id_sotrudnik,
    s.familiya,
    s.imya,
    s.otchestvo,
    d.dolzhnost
ORDER BY COUNT(dg.id_dogovor) DESC;