Scenario Based SQL Interview Question| SQL Interview Question| SQL Leetcode problems|Oracle database

Script:-

create table account_table(TransDate DateTime,TransId varchar(25),TransType varchar(20),Amount float);

insert into account_table values('2020-05-12 05:29:44','A10001','credit',50000);
insert into account_table values('2020-05-13 10:30:20','B10001','Debit',10000);
insert into account_table values('2020-05-13 11:27:50','B10002','credit',20000);
insert into account_table values('2020-05-14 08:35:30','C10001','Debit',5000);
insert into account_table values('2020-05-14 09:43:51','C10002','Debit',5000);
insert into account_table values('2020-05-15 05:51:11','D10001','credit',30000);

#googlesqlinterviewquestion#amazonsqlquestion#l&tsqlinterviewproblem#l&tsqlinterviewquestion#oracledatabase #sqlinterviewquestionsandanswers#groupbyclause#whereclause#orderbyclause#sql #aggregatefunctionsandscalarfunctions#referentialintegrity #foreignkey #whatisnormalization#normalization #normalizationkyahotahai#sqltips #leeetcode
#sqlcheatsheet#sqlserver#windowfunctions#constraints#constraintsinsql#keysinsql

[chandanpatra]

Good question. Keep bringing such type of questions.