The following SQL statement contains what type of subquery?

SELECT b$.$title, b$.$retail, a$.$category, a$.$cataverage

FROM books b$,($SELECT category, AVG$($retail$)$ cataverage

FROM books GROUP BY category$)$ a

WHERE b$.$category $=$ a$.$category;