Filtering Group By Results Based on a Value from Another Column in PostgreSQL

Understanding SQL CASE Statements: Which Approach is Most Effective/Quickest?

Simplifying Complex SQL Queries with Single Cross Apply/Case Expressions in SQL Server