AND OR Example

Have a table

Name| Age|City|
—— | —— | —— |
Bob| 10|Paris|
Mat| 20|Berlin|
Mary| 24|Prague|

select Name from table where Age>10 AND City='Prague'

Gives

|Name| | —— | |Mary|

—select Name from table where Age=10 OR City='Prague'

Gives

|Name| | —— | |Bob| |Mary|