Given the BOOKS table below, write a nested SQL query to obt…

Given the BOOKS table below, write a nested SQL query to obtain the books that retail for a price greater than the average retail price of books in every category. Your query should list the book title, retail price, and category. The results must be presented in ascending order of the book category. [Hint: you need to find the average retail price per book category] BOOK Table ISBN TITLE PUBDATE PUBID COST RETAIL CATEGORY