Re: [student] BQFH

....SELECT MAX(SUBTOT) new_max
> FROM ( SELECT SUM(S.CONC_SEATS_SOLD)
> + SUM(S.ORD_SEATS_SOLD) SUBTOT
> FROM SCREENING S
> GROUP BY S.FILM_NO)) max_film,

In this case, there must be a corresponding film for the screening. I suppose it does, but it's worth mentioning.

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---