---

SELECT
    u.familiya AS 'Фамилия',
    u.imya AS 'Имя',
    COUNT(s.id_shtrafa) AS 'Количество штрафов',
    SUM(vs.stoimost) AS 'Сумма штрафов, руб.'
FROM users u
JOIN dogovor d
    ON d.id_user = u.id_user
JOIN shtrafy s
    ON s.id_dogovor = d.id_dogovor
JOIN vidy_shtrafov vs
    ON vs.id_shtraf = s.id_shtrafa
GROUP BY
    u.id_user,
    u.familiya,
    u.imya
ORDER BY
    SUM(vs.stoimost) DESC;