CREATE TABLE manufacturers (code DECIMAL, name TEXT, headquarter TEXT, founder TEXT, revenue DECIMAL)
CREATE TABLE products (code DECIMAL, name TEXT, price DECIMAL, manufacturer DECIMAL)

Select the average price of each manufacturer's products, showing only the manufacturer's code.
SELECT AVG(price), manufacturer FROM products GROUP BY manufacturer
SELECT AVG("price"), "manufacturer" FROM "products" GROUP BY "manufacturer"