Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Numerical data types
Integer data types
Floating point data types
Decimal data types
Summary
17. Quiz

Instruction

Let's tackle the exercise we prepared for you.

Exercise

Peter is really happy with his website. He's decided to open an online store with products for people who fall in love. Heart-shaped balloons, rings, fresh flowers – anything you can imagine. Let's create a table called product for him. Take a look at the description below, decide on the data types, and provide a suitable SQL statement.

Each product has an id (an integer number) and a name that's 64 characters long at most. It also has a description, which can be of up to 256 characters. We also need the price for each product (all of them cost below $300.00). Last but not least, we want to store product weights in a column named weight and we are okay with small rounding errors.