These sorts of replies are very useful (and I do understand that they take experience, attention and effort to craft), even, I suspect, for some people that are more competent than me at just coding queries. In my (limited) experience, there are a lot of sometimes subtle and nuanced considerations, to say nothing of just things you may not know, that can go into even simple queries, let alone ones that perform a series of transforms, calculations and joins, and which need to be relatively fast and efficient because they will tend to be run regularly. I'm happy I am taking this stuff rather more seriously, I'm learning a lot.
... View more