Insert a New Employee

Write an INSERT statement that adds a new employee: id=9, name='Farah', department='Engineering', salary=75000. After your statement, the checker runs SELECT id, name, department, salary FROM employees ORDER BY id; to verify the table's full contents.

sql
CREATE TABLE employees (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  department TEXT NOT NULL,
  salary INTEGER NOT NULL
);

Sample data (this is the starting state before your statement runs):

sql
INSERT INTO employees (id, name, department, salary) VALUES
(1, 'Asha', 'Engineering', 85000),
(2, 'Rohan', 'Sales', 62000);