Write a set of SQL statements together to:
- create a new table
courses
with the following columns, data types and constraints.
column | data type | constraint |
---|
id | INTEGER | NOT NULL |
---|
name | TEXT | NOT NULL |
---|
abbreviation | TEXT | |
---|
- add these record rows to the created table
courses
id (INTEGER) | name (TEXT) | abbreviation (TEXT) |
---|
1 | JavaScript | js |