American Express SQL Interview Question | SQL Interview Preparation | Medium-Level

This video will help you calculate the average transaction amount per year for each client for the years 2018 to 2022. Table: transactions Script - -- Create the table CREATE TABLE transactions ( transaction_id INT PRIMARY KEY, user_id INT NOT NULL, transaction_date DATE NOT NULL, transaction_amount DECIMAL(10, 2) NOT NULL ); -- Insert the data into the table INSERT INTO transactions (transaction_id, user_id, transaction_date, transaction_amount) VALUES (1, 269, '2018-08-15', 500), (2, 478, '2018-11-25', 400), (3, 269, '2019-01-05', 1000), (4, 123, '2020-10-20', 600), (5, 478, '2021-07-05', 700), (6, 123, '2022-03-05', 900); #sql #dataanalysts #dataengineer #dataanalysis #interviewquestion #sqlinterview #sqlinterviewquestions