CREATE TABLE invoices (
    invoice_id INT PRIMARY KEY,
    vendor_name VARCHAR(100),
    country VARCHAR(50),
    invoice_amount DECIMAL(12,2),
    invoice_date DATE,
    payment_date DATE,
    processing_days INT,
    status VARCHAR(30)
);

INSERT INTO invoices
    (invoice_id, vendor_name, country, invoice_amount, invoice_date, payment_date, processing_days, status)
VALUES
    (1001, 'ABC Supplies', 'India', 25000.00, '2026-09-01', '2026-09-05', 4, 'Paid'),
    (1002, 'Global Tech Ltd', 'Germany', 45000.50, '2026-09-02', '2026-09-10', 8, 'Paid'),
    (1003, 'Euro Parts GmbH', 'Germany', 18500.75, '2026-09-03', NULL, 12, 'Pending'),
    (1004, 'Milan Components', 'Italy', 32000.00, '2026-09-04', '2026-09-15', 11, 'Paid'),
    (1005, 'Pune Industrial', 'India', 12000.00, '2026-09-05', NULL, 6, 'Pending'),
    (1006, 'Nordic Systems', 'Sweden', 56000.25, '2026-09-06', '2026-09-12', 6, 'Paid'),
    (1007, 'ABC Supplies', 'India', 31000.00, '2026-09-07', '2026-09-11', 4, 'Paid'),
    (1008, 'Rome Logistics', 'Italy', 22000.50, '2026-09-08', NULL, 9, 'Pending'),
    (1009, 'Global Tech Ltd', 'Germany', 67000.00, '2026-09-09', '2026-09-20', 11, 'Paid'),
    (1010, 'Pune Industrial', 'India', 15500.75, '2026-09-10', '2026-09-14', 4, 'Paid');