Seagull

Lesson 4 - 2. Create student Table

Dataset statusDemo datasetvv1

Exercise content

Create a table called student with these columns:

id primary key
name
age with constraint >= 18
grade with DEFAULT 0.0

Hints

Hint 1
Create student with id, name, age, grade. id must be the primary key.
Hint 2
On age, add a constraint that accepts only values >= 18. On grade, set a default value of 0.0.

Not completed

Loading dataset...

Latest result

No result set available.