-- Sample enterprise-style fact table (orders)
DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  order_date TEXT NOT NULL,
  region TEXT NOT NULL,
  product_category TEXT NOT NULL,
  channel TEXT NOT NULL,
  amount REAL NOT NULL
);

INSERT INTO orders (order_date, region, product_category, channel, amount) VALUES
('2025-01-05', 'North America', 'Electronics', 'Web', 120.50),
('2025-01-06', 'North America', 'Apparel', 'Retail', 45.00),
('2025-01-08', 'EMEA', 'Electronics', 'Web', 899.99),
('2025-01-10', 'APAC', 'Home', 'Web', 210.00),
('2025-01-12', 'North America', 'Electronics', 'Retail', 75.25),
('2025-02-01', 'EMEA', 'Apparel', 'Web', 62.00),
('2025-02-03', 'North America', 'Home', 'Web', 340.00),
('2025-02-14', 'North America', 'Electronics', 'Web', 1299.00),
('2025-02-20', 'APAC', 'Electronics', 'Retail', 540.50),
('2025-03-02', 'EMEA', 'Home', 'Web', 180.00),
('2025-03-05', 'North America', 'Apparel', 'Web', 88.00),
('2025-03-18', 'North America', 'Electronics', 'Web', 420.00),
('2025-03-22', 'APAC', 'Apparel', 'Web', 55.00),
('2025-04-01', 'EMEA', 'Electronics', 'Retail', 760.00),
('2025-04-10', 'North America', 'Home', 'Retail', 95.00);
