@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Tutor load'
define view entity {{P}}I_TUTOR_LOAD
  as select from {{p}}tutor as tutor
    inner join   {{p}}lesson as lesson on lesson.tutor_id = tutor.tutor_id
{
  key tutor.tutor_id        as tutor_id,
      tutor.tutor_name      as tutor_name,
      count( * )            as lesson_count,
      sum( lesson.dur_min ) as total_minutes
}
where lesson.dur_min > 0
group by
  tutor.tutor_id,
  tutor.tutor_name
having count( * ) >= 3