Incorrect query results when the results have duplicate column names

A query that selects properties or aliases with the same name returns only distinct properties in the results. As a general guideline, do not select properties or aliases with duplicate names. Ensure that each property in a result set has a distinct name.