ROUND tidies up a number

Averages often come back with a long tail of decimals. ROUND takes the number and how many decimal places you want, and gives back a neater version. It only changes what you see in the result — the numbers stored in the table stay exactly as they were.

SELECT ROUND(AVG(price), 2) AS average_price
FROM books;