How do I use the AVG function in SQL?

How do I use the AVG function in SQL?

The AVG function in SQL calculates the average value of a numeric column. You can use it like this: SELECT AVG(column_name) FROM table_name;

Can I use AVG with a WHERE clause?

Yes, you can! For example: SELECT AVG(column_name) FROM table_name WHERE condition; This will calculate the average only for the rows that meet the condition.

What if I want to group the results by another column?

You can use the GROUP BY clause. For example: SELECT another_column, AVG(column_name) FROM table_name GROUP BY another_column; This will give you the average for each group.

Can AVG be used with multiple columns?

No, the AVG function can only be applied to one column at a time. You would need to call it separately for each column.