-- Step 1: Create the transactions table
CREATE TABLE transactions (
transaction_id INT,
customer_id INT,
transaction_type VARCHAR,
amount DECIMAL,
currency VARCHAR,
transaction_tp TIMESTAMP,
transaction_status VARCHAR
);
-- Step 2: Insert sample data into the transactions table
INSERT INTO transactions (transaction_id, customer_id, transaction_type, amount, currency, transaction_tp, transaction_status) VALUES
(1, 101, 'Deposit', 500.00, 'USD', '2024-03-15 09:30:00', 'Completed'),
(2, 102, 'Withdrawal', 200.00, 'EUR', '2024-03-15 10:15:00', 'Pending'),
(3, 103, 'Transfer', 1000.00, 'GBP', '2024-03-15 11:00:00', 'Completed'),
(4, 104, 'Deposit', 250.50, 'INR', '2024-03-15 12:45:00', 'Failed'),
(5, 105, 'Withdrawal', 750.75, 'USD', '2024-03-15 14:20:00', 'Completed'),
(6, 106, 'Transfer', 5000.00, 'EUR', '2024-03-15 15:30:00', 'Pending');
-- Step 3: Show data insertion
SELECT * FROM transactions;