1. and 和 or 地位是一样的,可以相互替换
2. ()比and 和 or 级别高

SELECT * FROM Persons WHERE (FirstName='Thomas' OR FirstName='William')
AND LastName='Carter'

SELECT * FROM Persons WHERE (FirstName='Thomas' AND FirstName='William')
OR LastName='Carter'