Remove DISTINCT inside singleton queries

[ranma42]

When a (sub)query results in 0 or 1 elements (First(), Last(), FirstOrDefault(), LastOrDefault(), Take(0/1), ...), DISTINCT has no effect and can be removed.

Conceptually this is a continuation of #31016

[roji]

Makes sense, thanks @ranma42.