6. Filtering with WHERE and Equals

1SELECT columns
2FROM table_name
3WHERE condition;

1SELECT * FROM students
2WHERE course = 'Python';

1-- Filter by course
2SELECT * FROM students WHERE course = 'Python';
3
4-- Filter by grade
5SELECT * FROM students WHERE grade = 'A';
6
7-- Filter by age
8SELECT * FROM students WHERE age = 14;

1-- Strings need quotes
2SELECT * FROM students WHERE name = 'Alice';
3
4-- Numbers don't need quotes
5SELECT * FROM students WHERE age = 14;
6
7-- But this also works (not recommended)
8SELECT * FROM students WHERE age = '14';

1-- May or may not match 'Python'
2SELECT * FROM students WHERE course = 'python';