Creating tables

CREATE TABLE - Data types

Write an SQL statement to create a new table books with the following columns. Try and use the right data types on the basis of information given about the columns.

Column Description
id a serial number id for the book, a positive whole number
name name of the book
price price of the book in dollars, can be a decimal or integer value