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

Transforming Table Structure: SQL Query for Aggregating Data