Hey @CosmicPangolin1
Can you please share a small data set on which I can run this query and the JSON result that you expect this query to run? I think what you are asking for is possible (by Query 3 you mentioned above) but maybe I am missing something.