Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Data Types in SQL

Introduction
Final Quiz
4. Question 3
Summary

Instruction

Perfect! Let's try identities and boolean columns now.

Exercise

In the American Grand Star Hotel, there are various kinds of rooms. Let's make a table named room with these columns:

  1. room_id – An integer and the primary key, which is always auto-generated as an identity.
  2. door_number – Exactly three characters.
  3. basic_price – A money value with 6 digits, of which two are after the decimal point.
  4. sauna_available – A yes/no field.