Which of the SQL statement will give an incorrect output for the following query:
Print the sum of total marks of all those students whose roll number is between 500 and 1000.1
Select sum(marks) from student where roll_no >= 500 and roll_no <=1000
2
Select sum(marks) from student where roll_no between 500 and 1000
3
Select sum(marks) from student where roll_no in (500, 100)
4
None of the above