44. Remove all orders from customer Chandu.

DELETE FROM
    orders
WHERE
    cnum = (
        SELECT
            cnum
        FROM
            customer
        WHERE
            cname = 'Chandu'
    );

Output: