Como hacer este select Anidado----

[Linterns]

a ver si te funciona esto

Código:

select products_category.category_description, 
        AVG(products.price)
from products_category, products
Where products_category.category_id = products.category_id
Group by products_category.category_description;