Question: Consider a table named transactions representing financial transactions in a bank. Your task is to write a query to find the accounts that have had
Consider a table named transactions representing financial transactions in a bank.
Your task is to write a query to find the accounts that have had at least three consecutive transactions where the sum of amounts is positive. Display the accountid the starting date of the consecutive transactions, and the ending date of the consecutive transactions.
Tables Schema as Below:
transactions
columnName dataType
transactionid INT
accountid INT
transactiondate DATE
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
