Home/ Questions/Q 241696
Next
In Process

Answerclub Latest Questions

Aryan Prajapat
  • 0
  • 0
Knowledge Contributor
Asked: 2024-10-09T11:25:55+05:30 In:

Is the following query returns the output? SELECT subject_code, AVG (marks) FROM Students WHERE AVG(marks) > 70 GROUP BY subject_code;

  • 0
  • 0
Is the following query returns the output? SELECT subject_code, AVG (marks) FROM Students WHERE AVG(marks) > 70 GROUP BY subject_code;

1 Answer

  1. Aryan Prajapat
    Knowledge Contributor

    No. The above query does not return the output because we cannot use the WHERE clause to restrict the groups. We need to use the HAVING clause instead of the WHERE clause to get the correct output.

You must login to add an answer.

Need An Account,