Creating a SELECT and GROUP query in Google Sheets results in a duplicate ‘group’ column (Col Q) at the end which I want to remove. I don’t know where to introduce the CHOOSECOLS function in the query function:

select Q, Y, J, max(Q) where Y is not null and not Y like ‘[%’ group by Q, Y, J

Where do I put the CHOOSECOLS function in the above query?

I tried putting the CHOOSECOLS function at the end of the query but this resulted in an error.