group by in query google sheet select different columns stackoverflow

Recent Questions - Web Applications Stack Exchange

Want to get the results described on the screenshot. How can i achieve it. Thank you.

QUERY:

=QUERY(A2:F12,"SELECT A, MAX(B), MIN(B) group by A label A 'G V1', MAX(B) 'LAST V2', MIN(B) 'FIRST V2'")

Want to get First & last V5 value in terms of max and min dates in V2 (see K2, L2 desired results), I could get the last and first dates now i want their V5 corresponding.

Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by Mostav via Recent Questions - Web Applications Stack Exchange