EY Interview Question | Derive the Net Balance of the Transaction Amount | SQL Interview Question
In this video we will solve a Data Analyst SQL interview question.
Table Script :-
create table transactions(
TranDate datetime, TranID varchar(20),
TranType varchar(20), Amount int)
insert into transactions(TranDate, TranID, TranType, Amount)
values('2099-05-12 05:29:44.120','A10001','Credit',50000),
('2099-05-13 10:30:20.100','B10001','Debit',10000),
('2099-05-13 11:27:50.130','B10002','Credit',20000),
('2099-05-14 08:35:30.123','C10001','Debit',5000),
('2099-05-14 09:43:51.100','C10002','Debit',5000),
('2099-05-15 05:51:11.117','D10001','Credit',30000)
🔍 Looking for something specific? Check out my curated playlists.
✅Complex SQL Interview Questions
• Complex SQL Interview Questions: Mast...
✅SQL Interview Questions
• SQL Interview Bootcamp: Questions & P...
✅SQL Mastery Interview Prep
• SQL Concepts: Detailed Interview Ques...
✅Learn SQL Concepts
• SQL Fundamentals: Key Concepts and Sk...
✅SQL Functions
• SQL Functions Explained: Practical Us...
📩 Contact: For any inquiries or collaborations, please email me at [email protected]
Don't forget to hit the subscribe button and ring the notification bell to never miss an update! Become a valued member of our passionate community and be part of the journey with me!
Thanks for watching, and see you in the next video!" 🚀