@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Bike usage'
define view entity {{P}}I_BIKE_USE
  as select from {{p}}bike as bike
    inner join   {{p}}ride as ride on ride.bike_id = bike.bike_id
{
  key bike.bike_id            as bike_id,
      bike.station            as station,
      count( * )              as ride_count,
      sum( ride.distance_km ) as total_distance
}
group by
  bike.bike_id,
  bike.station
having
  sum( ride.distance_km ) > 50.0