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 |