How to retrieve/"Select" Date Using Query

Question

I Have the following Query string:

=QUERY(Scores!$A$3:$E, "SELECT A, min(D) WHERE (C = 'X30' AND B = 'East Palm') GROUP BY A ORDER BY min(D) ASC LIMIT 5 LABEL min(D) ''",0)

And will also like to retrieve the date from the data (Column E), I tried

=QUERY(Scores!$A$3:$E, "SELECT A, E min(D)...

but it did not work and received the following message:

Error Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered ".

I have attached the Form link if anyone can help...

https://docs.google.com/spreadsheets/d/1M5T-stwFQmPFqVDfxKH3Jh46JcQPauvCl5fV4opmgMQ/edit#gid=2146752760

player0 player0 · Accepted Answer · 2019-10-17T17:40:12

if you want dates you also need to include it under group by like:

=QUERY(Scores!$A$3:$E, 
 "select A,E,min(D) 
  where C = 'X30' 
    and B = 'East Palm' 
  group by A,E 
  order by min(D) asc 
  limit 5 
  label min(D) ''", 0)

How to retrieve/"Select" Date Using Query

2 Answers