Conditional statements part 1
Sometimes we would like to fetch records that meet a certain condition.
For example
- fetch all of the records that have the family name "Aothly"
- fetch all of the records that the amount is bigger than 5
- fetch all of the records with the country "Mexico"
To add condition we can use the WHERE keyword
sales
| coin | amount |
| AGK | 13 |
| GOL | 21 |
| KLA | 15 |
| AGK | 18 |
To fetch all of the records with the coin "AGK" we will write:
SELECT * FROM sales WHERE coin = "AGK"
To fetch all of the records with amount smaller than 20 we will write:
SELECT * FROM sales WHERE amount < 20