@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Milk totals per farm'
define view entity {{P}}I_MILK_TOTAL
  as select from {{p}}milk as milk
    inner join   {{p}}farm as farm on farm.farm_id = milk.farm_id
{
  key milk.farm_id       as farm_id,
      farm.farmer        as farmer,
      max( milk.litres ) as total_litres,
      count( * )         as delivery_count
}
group by
  milk.farm_id,
  farm.farmer
having
  sum( milk.litres ) > 500