Add a Website Column

Every department is getting a web page. Add a column named website of type TEXT to the departments table. It may hold NULL, so no constraint or default is needed: the existing six rows simply get an empty value.

Expected result:

Table departments
✓ id INTEGER PRIMARY KEY
✓ code TEXT NOT NULL
✓ name TEXT NOT NULL
✓ building TEXT
✓ budget REAL
✓ founded_year INTEGER
✓ phone TEXT
✓ email TEXT
✓ is_active INTEGER NOT NULL DEFAULT 1
✓ head_instructor_id INTEGER
✓ website TEXT
✓ UNIQUE (code)

Hints3 available

Topics:

ALTER & DROP

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.