What is the average price of cars with 8 cylinders?
with 8 cylinders refers to cylinders = 8; average price = avg(price) where cylinders = 8
SELECT AVG(T2.price) FROM data AS T1 INNER JOIN price AS T2 ON T1.ID = T2.ID WHERE T1.cylinders = 8