Calculating Multiple Aggregated Values and Their Final Sum in a Single Column Using Postgres SQL

Understanding PostgreSQL's Maximum Scalar Values Limitation in IN Clauses