Solution: Use Columns Unambiguously

The sections that follow describe several ways we can resolve this antipattern and write unambiguous queries.

Query only functionally dependent columns

The most straightforward solution is to eliminate ambiguous columns from the query.