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|