48. Delete all customers with no current orders.

DELETE FROM
    customer
WHERE
    cnum NOT IN (
        SELECT
            cnum
        FROM
            orders
    );

Output: