write a sql query find average marks in each course but average marks should be greater than 40.
Answers
Answered by
1
Dear user,
Kindly mark the answer as brainliest if you find it useful.
Here's the statement:
SELECT AVG( COLOUMN NAME) FROM TABLE NAME GROUP BY COURSE HAVING AVG>40;
Hope this clears your doubt.
Kindly mark the answer as brainliest if you find it useful.
Here's the statement:
SELECT AVG( COLOUMN NAME) FROM TABLE NAME GROUP BY COURSE HAVING AVG>40;
Hope this clears your doubt.
Similar questions