SQL And, Or, Not
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)
Task
Swipe to start coding
Find all songs titles and prices of 20th century, where the price is less than 500, or where the singer is AC/DC.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
