Updating Column String Value Based on Multiple Criteria in Other Columns Using Boolean Masks and Chained Comparisons

How to Use Subselect, Group by, and Having Count with Criteria in Hibernate