Show each book’s title, price, and the overall average price (same on every row) as avg_all.

Answer

SELECT title, price, AVG(price) OVER () AS avg_all FROM books;