Skip
Arish's avatar

24. Practice - AND Condition


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;