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 |
---|
courseId | INTEGER | PRIMARY KEY |
name | TEXT | NOT NULL |
abbreviation | TEXT | |
- add these record rows to the created table
courses
courseId (INTEGER) | name (TEXT) | abbreviation (TEXT) |
---|
1 | Ruby | rb |
2 | SQL | sql |