Exercise: Range with Course
Find JavaScript students with marks between 70 and 85.
Solution
sql
1SELECT * FROM students
2WHERE course = 'JavaScript'
3AND marks BETWEEN 70 AND 85;
Find JavaScript students with marks between 70 and 85.
1SELECT * FROM students
2WHERE course = 'JavaScript'
3AND marks BETWEEN 70 AND 85;