Combine Google Sheet Queries into one single Query?-CodePudding

I think this is a relatively straightforward question, but just don't know how to make it work. Is it possible to combine below two formulas into single query in one go?

=QUERY(A:E,"SELECT Max(C),Min(D),Sum(E)")
=QUERY(A:E,"SELECT B where DAY(A)<=3")

I tried something like these, but doesn't work

=QUERY(A:E,"SELECT B where DAY(A)<=3,Max(C),Min(D),Sum(E)") or
=QUERY(A:E,"SELECT B where DAY(A)<=3,SELECT Max(C),Min(D),Sum(E)")

Thank you!

CodePudding user response：

Try below QUERY() function.

=QUERY(A:E,"SELECT B, Max(C), Min(D), Sum(E) where A is not null and DAY(A)<=3 group by B")