A million apologies for the delayed acknowledgement of your email. The Yahoo webmail is doing weird things with conversations (your email was hiding in my sent box instead of inbox, tagged onto the end of my original email !).
But I digress. I will take a look at your suggestions and get back to you over the next day or so.
Thank you
Tim
On Monday, 4 August 2014, 18:46, Serge Fonville <serge.fonville@gmail.com> wrote:
WITH NormCTE AS ( SELECT delta - avg(delta))/stddev(delta) AS deltaNorm , (echo - avg(echo))/stddev(echo) AS echoNorm , (foxtrot - avg(foxtrot))/stddev(foxtrot) AS foxtrotNorm FROM t_subs ) SELECT deltaNorm + echoNorm + foxtrotNorm AS normSum FROM NormCTE ORDER BY normSum DESC
I'm on Postgres 9.3.5, however I think my knowledge of Postgres is not deep enough to help me with this challenge, so here I am reaching out to the community !