31. Find all orders of the salesman who services 'Hardik'.

SELECT
    *
FROM
    orders
WHERE
    snum = (
        SELECT
            snum
        FROM
            customer
        WHERE
            cname = 'Hardik'
    );

Output: