6. List out names and cities of all salesmen in London with commission above 10%.

SELECT
    sname,
    city
FROM
    salesman
WHERE
    city = 'London'
    AND commission > 10;

Output: