42. Insert all the rows of salesmen table with city London in the London staff table.

INSERT INTO
    londonstaff
SELECT
    *
FROM
    salesman
WHERE
    city = 'London';

Output: