Taking the query from this website as an example :is it possible to do something like this ?I've shortened it down everything to a minimum while still showing the result I'm looking for (and yes I know it doesn't work!).
What I have at the moment is something like the following...So is there anyway of getting closer to what I'm after?
Will a projection help me?
Or will I always have to iterate over the result to sort it?