Oracle SQL Question:

Write a query that displays the category_name, product_name and list_price of all products whose list price is less than the average list price for all products in its same category.

Sort the results by category_name in ascending sequence, then list_price in descending sequence

Statements must have at least one subquery (except as indicated), and use explicit join syntax, without relying on the USING or NATURAL keywords.