Question: im not getting the correct output for the test case using the given code / * Enter your query below. Please append a semicolon
im not getting the correct output for the test case using the given code
Enter your query below.
Please append a semicolon ; at the end of the query
SELECT
sender
MINdt AS sequencestart,
MAXdt AS sequenceend,
COUNT AS transactionscount,
ROUNDSUMamount AS transactionssum
FROM
transactions
GROUP BY
sender
FLOORUNIXTIMESTAMPdt
HAVING
transactionscount
AND transactionssum
ORDER BY
sender ASC,
sequencestart ASC,
sequenceend ASC;
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
