16 lines
402 B
Plaintext
16 lines
402 B
Plaintext
@AccessControl.authorizationCheck: #NOT_REQUIRED
|
|
@EndUserText.label: 'Film revenue'
|
|
define view entity {{P}}I_FILM_REVENUE
|
|
as select from {{p}}screen as s
|
|
inner join {{p}}ticket as t on t.show_id = s.show_id
|
|
{
|
|
key s.show_id as show_id,
|
|
s.film as film,
|
|
count( * ) as ticket_count,
|
|
sum( t.price ) as revenue
|
|
}
|
|
where s.status = 'A'
|
|
group by
|
|
s.show_id,
|
|
s.film
|