-- Sample SQL dump generated by example-file.com
CREATE TABLE products (
  sku VARCHAR(10) PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  qty INTEGER NOT NULL,
  unit_price DECIMAL(10,2) NOT NULL
);

INSERT INTO products (sku, name, qty, unit_price) VALUES
  ('1001', 'Example Widget Small', 2, 19.99),
  ('1002', 'Example Widget Medium', 1, 29.99),
  ('1003', 'Example Widget Large', 3, 39.99),
  ('1004', 'Example Widget Pro', 1, 59.99);

CREATE TABLE orders (
  id INTEGER PRIMARY KEY,
  product_sku VARCHAR(10) NOT NULL REFERENCES products(sku),
  quantity INTEGER NOT NULL,
  ordered_at TIMESTAMP NOT NULL
);

INSERT INTO orders (id, product_sku, quantity, ordered_at) VALUES
  (1, '1001', 1, '2026-01-05 10:15:00'),
  (2, '1003', 2, '2026-01-06 14:42:00'),
  (3, '1002', 1, '2026-01-08 09:03:00');
