Write a query to display the highest average obtained from the students.Give an alias as avg_mark. Round the result to 2 decimal places.
Answers
Answered by
0
Answer:
SELECT MAX(ROUND(AVG(value),2)) as avg_mark
from Mark GROUP BY student id;
Explanation:
MAX() returns the largest value of the targeted column.
AVG() returns the average value of a numeric column.
"as" keyword is used to give an alias.
ROUND() rounds a number to a specified number of decimal places.
GROUP BY statement groups rows that have the same values. It is used with aggregate functions to group the result-set by one or more columns.
#SPJ2
Answered by
0
Answer:
mark me as brainliest
Explanation:
Similar questions