To combine multiple conditions, use **AND**, **OR**, and **NOT** keywords, and also brackets **(**, **)** to set the priority.

For example, you want to select all songs' titles, that were produced between 1970 and 1990 years:

SELECT title FROM songs
WHERE year >= 1970 AND year <= 1990

Or you can select all records where singer is not Pink Floyd:

SELECT * FROM songs
WHERE NOT singer = 'Pink Floyd'

You can combine conditions for different columns, but not forget about brackets to define the priority:

SELECT * FROM songs
WHERE NOT (singer = 'Pink Floyd' AND price = 100)

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL And, Or, Not

Lösung