Q. What does this query do?

Code:
SELECT AVG(salary) FROM employees;
  • (A) Calculates total salary
  • (B) Calculates average salary
  • (C) Returns highest salary
  • (D) Counts number of salaries
πŸ’¬ Discuss
βœ… Correct Answer: (B) Calculates average salary
Explanation: `AVG()` returns the average of the values in the specified column.
Explanation by: Mr. Dubey
`AVG()` returns the average of the values in the specified column.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
79
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
91%
Success Rate