📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    Question

    Which SQL function is used to calculate the average of a

    numeric column?
    A SUM() Correct Answer Incorrect Answer
    B AVG() Correct Answer Incorrect Answer
    C COUNT() Correct Answer Incorrect Answer
    D MAX() Correct Answer Incorrect Answer
    E MIN() Correct Answer Incorrect Answer

    Solution

    AVG() computes the arithmetic mean of all non-NULL values in a numeric column.

    Practice Next
    ask-question