The following SQL statement contains which type of subquery?

SELECT title, retail, category, cataverage FROM books NATURAL JOIN

$($SELECT category, AVG$($retail$)$ cataverage FROM books GROUP BY category$)$;