Grouping Data by Foreign Key and Date with Total by Date Using Conditional Aggregation

Conditional Aggregation for Multiple Columns from One Column in MS Access: A Practical Guide

Grouping By with Aggregate for Getting Record In SQL Server?

How to Achieve Conditional Model Results with PostgreSQL's bool_or Function and Advanced Techniques