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

What are the names and average prices of products for manufacturers whose products cost on average 150 or more?
SELECT AVG(T1.price), T2.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.manufacturer = T2.code GROUP BY T2.name HAVING AVG(T1.price) >= 150
SELECT AVG("T1"."price"), "T2"."name" FROM "products" AS "T1" JOIN "manufacturers" AS "T2" ON "T1"."manufacturer" = "T2"."code" GROUP BY "T2"."name" HAVING AVG("T1"."price") >= 150