SQL TABLE CREATION AND UPDATEING

Following is sample SQL code to crate and update table.

-- create
CREATE TABLE EMPLOYEE (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  dept TEXT NOT NULL
);

-- insert
INSERT INTO EMPLOYEE VALUES (0001, 'Clark', 'Sales');
INSERT INTO EMPLOYEE VALUES (0002, 'Dave', 'Accounting');
INSERT INTO EMPLOYEE VALUES (0003, 'Ava', 'Sales');

-- update
-- UPDATE 
UPDATE EMPLOYEE SET name = 'Mark' WHERE empId = 1;

-- fetch 
-- SELECT * FROM EMPLOYEE WHERE dept = 'Sales';
SELECT * FROM EMPLOYEE;

-- NEW TABLE 
CREATE TABLE stud (
stuid INTEGER PRIMARY KEY,
name TEXT NOT NULL,
house TEXT NOT NULL
);

INSERT INTO stud VALUES (1,"Max", "Red House");
INSERT INTO stud VALUES (2,"Joshua", "Blue House");
INSERT INTO stud VALUES (3,"Son", "Green House");

SELECT * FROM stud;