Comment by bifel

Using distinct and windowing functions to avoid writing group-by clauses may work fine with Postgres but is a very ugly hack.