Exercise: Multiple Conditions
Find students in grade A AND aged 14.
Solution
sql
1SELECT * FROM students
2WHERE grade = 'A'
3AND age = 14;Practice More
sql
1-- JavaScript students with marks above 75
2SELECT * FROM students
3WHERE course = 'JavaScript'
4AND marks > 75;
5
6-- Grade B students older than 12
7SELECT * FROM students
8WHERE grade = 'B'
9AND age > 12;