Online DuckDB Playground

-- Create a sequence to provide an integer primary key for the table
DROP SEQUENCE IF EXISTS id_sequence CASCADE;
CREATE SEQUENCE id_sequence START 1;

-- Create the users table
DROP TABLE IF EXISTS users;
CREATE TABLE users (
    id INTEGER DEFAULT nextval('id_sequence'),
    username VARCHAR(50) NOT NULL UNIQUE,
    email VARCHAR(100) NOT NULL UNIQUE,
    full_name VARCHAR(100) NOT NULL,
    age INTEGER,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert 10 rows of test data
INSERT INTO users (username, email, full_name, age) VALUES
    ('john_doe', 'john.doe@example.com', 'John Doe', 30),
    ('jane_smith', 'jane.smith@example.com', 'Jane Smith', 28),
    ('bob_johnson', 'bob.johnson@example.com', 'Bob Johnson', 35),
    ('alice_williams', 'alice.williams@example.com', 'Alice Williams', 26),
    ('charlie_brown', 'charlie.brown@example.com', 'Charlie Brown', 22),
    ('diana_miller', 'diana.miller@example.com', 'Diana Miller', 31),
    ('eric_davis', 'eric.davis@example.com', 'Eric Davis', 29),
    ('fiona_taylor', 'fiona.taylor@example.com', 'Fiona Taylor', 33),
    ('george_wilson', 'george.wilson@example.com', 'George Wilson', 27),
    ('hannah_moore', 'hannah.moore@example.com', 'Hannah Moore', 24);