Skip to content

DuckDB

Testing

-- Create a table named 'students'
CREATE TABLE students (
    name TEXT,
    age INTEGER,
    grade TEXT
);

-- Insert some data into the 'students' table
INSERT INTO students (name, age, grade) VALUES ('Alice', 18, 'A');
INSERT INTO students (name, age, grade) VALUES ('Bob', 19, 'B');
INSERT INTO students (name, age, grade) VALUES ('Charlie', 17, 'B');
INSERT INTO students (name, age, grade) VALUES ('David', 20, 'A');


select count(*) from students;