You create a table that has the StudentCode, SubjectCode, and Marks columns to record mid-year marks for students. The table has marks obtained by 50 students for various subjects.
You need to ensure that the following requirements are met:
Students must be ranked based on their average marks.

If one or more students have the same average, the same rank must be given to these students.

Ranks must be sequential without gaps in between.

Which Transact-SQL query should you use?
A:

B:

C:

D:

E:

F:

G:

H: