123

an anonymous user · August 01, 2020 · SQL
-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
-- insert some valuesTO students VALUES (1, 'Ryan', 'M');
INSERT INts VALUES (2, 'Joanna', 'F');
-- f
SELECT * FROM students WHERE gender = 'F';

Comments

Please sign up or log in to contribute to the discussion.