Generate Custom SQL Queries & Database Schemas

-- Create products table with constraints
CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    category_id INTEGER REFERENCES categories(id),
    price DECIMAL(10,2) CHECK (price > 0),
    in_stock BOOLEAN DEFAULT true,
    created_at TIMESTAMP DEFAULT NOW()
);

-- Insert realistic test data
INSERT INTO products (name, category_id, price, in_stock)
VALUES
  ('MacBook Pro 16"', 1, 2499.00, true),
  ('Wireless Mouse', 2, 79.99, true),
  ('USB-C Hub', 2, 49.95, false);