Using Melt to Loop Over a Vector in Data.table: Filtering and Summarizing with by

Grouping Rows in SQL Based on Column Sum Value Without Exceeding a Specified Limit

Understanding naniar with dplyr: Navigating Changes in R's Grouping Functionality

Grouping Items Together Based on a Value in Another Column: A SQL Solution