Interview Question

What is AVG()?

AVG returns the mean of non-null inputs.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

AVG calculates the arithmetic mean of non-null input values. • Null inputs are ignored. • The result type depends on the input type and database. • AVG can be used over all rows, grouped rows, or a window.

💡 SQL Example

SELECT AVG(salary) FROM employees;

Result

54285.71

⚡ Quick Revision

AVG returns the mean of non-null inputs.

←

PreviousWhat is SUM()?

NextWhat is MAX()?

→