#2 American Express SQL Question | Credit Limit

CREATE TABLE users (
user_id INT,
user_name VARCHAR(50),
credit_limit INT
);

CREATE TABLE transactions (
trans_id INT,
paid_by INT,
paid_to INT,
amount INT,
trans_date DATE
);

INSERT INTO users(user_id, user_name, credit_limit) VALUES
(1, 'Peter', 100),
(2, 'Roger', 200),
(3, 'Jack', 10000),
(4, 'John', 800);

INSERT INTO transactions(trans_id, paid_by, paid_to, amount, trans_date) VALUES
(1, 1, 3, 400, '01-01-2024'),
(2, 3, 2, 500, '02-01-2024'),
(3, 2, 1, 200, '02-01-2024');

Видео #2 American Express SQL Question | Credit Limit канала Corpverse