PostgreSQL - “DISTINCT ON”和“GROUP BY”语法

I realized that a database query was returning unexpected results do to my improper use of "DISTINCT ON" and "GROUP BY"I realized that a database query was returning