I did remove the GROUP BY and and achieved the correct result. My original post shows a 2nd script without GROUP BY.