Comparison Search Condition
List all staff with a salary greater than 10,000.

SELECT staffNo, fName, lName, position, salary FROM Staff WHERE salary > 10000;


Compound Comparison Search Condition
List addresses of all branch offices in London or Glasgow.

SELECT * FROM Branch WHERE city ='LONDON' Or city = 'Glasgow'