35. Find all customers having rating greater than any customer in 'Rome'.

SELECT
    cname,
    cnum
FROM
    customer
WHERE
    rating > (
        SELECT
            MAX(rating)
        FROM
            customer
        WHERE
            city = 'Rome'
    );

Output: