Delete Exam 3 (Take into consideration that there might be confl

Raw Download Revise

-- Delete records from referencing tables first

DELETE FROM board_games

WHERE publisher_id IN (

    SELECT id

    FROM publishers

    WHERE address_id IN (

        SELECT id

        FROM addresses

        WHERE town LIKE 'L%'

    )

);

DELETE FROM publishers

WHERE address_id IN (

    SELECT id

    FROM addresses

    WHERE town LIKE 'L%'

);

-- Delete records from addresses table

DELETE FROM addresses

WHERE town LIKE 'L%';