Question

Consider a table called "students", having the
following column fields:
"id" (type: INT)
"name" (type: TEXT)
"marks" (type: INT)
Write a SQL query which will calculate the
average of the marks of the students passing.
The passing criteria is that the marks should be
at least 40. The average marks are to be
returned using the column name
'marksaverage'.

Answer 1

Answer:

select Id, name, mark ,'marksaverage' from students

where marks>=40;

I guess it's right