Find the titles and prices of books priced above the overall average price.

Answer

SELECT title, price FROM books WHERE price > (SELECT AVG(price) FROM books);