The Head of the Department of Electronics in a college wants to see a list of students who secured less than the average marks of all the students. The data pertaining to the same is present in the STUDENT table. Which of the following query$($s$)$ can be used to accomplish the task? SQL QUERY

Select only one option

SELECT NAME FROM STUDENT WHERE MARKS $<($SELECT AVG$($MARKS$)$ FROM STUDENT$)$;

SELECT NAME FROM STUDENT WHERE MARKS $<$ AVG$($MARKS$)$;

SELECT NAME FROM STUDENT HAVING MARKS $<($SELECT AVG$($MARKS$)$ FROM STUDENT$)$;

SELECT NAME FROM STUDENT WHERE MARKS IN $($SELECT AVG$($MARKS$)$ IN STUDENT$)$;