Learn SQL
Adding and updating columns

Adding columns to table

There are two tables courses and teachers, given below. Write a set of SQL statements to add these new columns to specified tables.

table new column name data type constraint
courses startedIn INTEGER DEFAULT 2015
teachers courseId INTEGER NOT NULL, DEFAULT 1