---

SELECT
    u.id_user AS `ID клиента`,
    u.familiya AS `Фамилия`,
    u.imya AS `Имя`,
    CASE
        WHEN (
            SELECT COUNT(*)
            FROM dogovor d
            WHERE d.id_user = u.id_user
        ) > 2
        THEN 'Многоразовый клиент'
        ELSE 'Просрочены права'
    END AS `Причина`
FROM users u
WHERE
    (
        SELECT COUNT(*)
        FROM dogovor d
        WHERE d.id_user = u.id_user
    ) > 2
    OR EXISTS (
        SELECT 1
        FROM prava p
        WHERE p.id_user = u.id_user
          AND p.data_okonchaniya < CURDATE()
    )
ORDER BY u.familiya ASC;