To use AND and OR both together in google sheet query

Question

Is there any way I can use both operator i.e. AND and OR in the Google Sheets Query. For e.g.

"Select * where Col1 contains 'Yes' or Col2 contains 'Yes' and Col3 contains 'Please'"

Answer 1

Try

"Select * where (Col1 contains 'Yes' or Col2 contains 'Yes') and Col3 contains 'Please'"

add parenthesis