Show each title, its price, the price rounded to whole dollars (as rounded), and the price cast to an integer (as as_int).
Show each title, its price, the price rounded to whole dollars (as rounded), and the price cast to an integer (as as_int).
Answer
SELECT title, price, round(price) AS rounded, price::int AS as_int FROM books;