Java Persistence/Ebean/Aggregation - Group By

There are 3 main ways you can do "Aggregation" type queries (with GROUP BY and HAVING clauses).

1. SQL
2. @SqlSelect - Report Bean
3. @SqlSelect - Normal Bean
4. @Formula