Please note that in "only one row is shows for each distinct" the word "show" should be "shown". Trivial I know in excellently written documentation.