-- create a table
CREATE TABLE students (
  roll number INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  age   Number NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ram', 'M', 15);
INSERT INTO students VALUES (2, 'Sita', 'F', 16);
INSERT INTO students VALUES (3,  'Jayesh', 'M', 16);
INSERT INTO students VALUES (4,   'Aand', 'M', 16);
INSERT INTO students VALUES (5,  'Shiva',  'M', 16);
ALTER table students ADD class  INTEGER;
UPDATE students set class = 10 Where age = 16 ; 
SELECT*FROM students where class = 10 ;