@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Lessons with instructor'
define view entity {{P}}I_LESSON_INSTR
  as select from {{p}}lesson as lesson
    association [1..1] to {{p}}instr as _instructor
      on lesson.instr_id = _instructor.instr_id
{
  key lesson.lesson_id      as lesson_id,
      lesson.instr_id       as instr_id,
      lesson.lesson_date    as lesson_date,
      lesson.duration       as duration,
      lesson.fee            as fee,
      _instructor.full_name as instructor_name,
      _instructor.city      as instructor_city,
      _instructor
}
where lesson.duration >= 45