Find the average price of all products in a database.

Problem

Write a SQL query to find the average price of all products in the database.
Example input:
Product table:
+----+-------------+-------------+
| id | name        | price      |
+----+-------------+-------------+
| 1  | Product 1   | 10.00      |
| 2  | Product 2   | 20.00      |
| 3  | Product 3   | 30.00      |
+----+-------------+-------------+
Output:
+-------------+
| average     |
+-------------+
| 20.00       |
+-------------+

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

SELECT AVG(price) AS average
FROM Product;