Skip to main content

2

sql

-- Create a students table
CREATE TABLE students_info (
  id INTEGER,
  name TEXT,
  grade INTEGER,
  passed TEXT
);

-- Insert a few records
INSERT INTO students_info (id, name, grade, passed) VALUES
(1, 'John Miller', 92, 'yes'),
(2, 'Emily Davis', 88, 'yes'),
(3, 'Michael Johnson', 59, 'no');

-- View all data in the students table
SELECT * FROM students_info;

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.

sql