Count how many books are in the shop. Name the column total.

Answer

SELECT COUNT(*) AS total FROM books;