Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started