Create Table, insert data and query data from table

 Create Table, insert data and query data from table

-- create a table DDL

CREATE TABLE students (

  id INTEGER primary key,

  name TEXT ,

  gender TEXT

);

-- insert some values

INSERT INTO students VALUES (1, 'Ryan', 'M');

INSERT INTO students VALUES (2, 'Joanna', 'F');

--Query data

SELECT * FROM students;

1|Ryan|M
2|Joanna|F