Xref: alice comp.databases.oracle.misc:21772
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!newsfeed.gamma.ru!Gamma.RU!newsfeed.wirehub.nl!xs4all!not-for-mail
From: martinj(replace this with @)xs4all.nl
Newsgroups: comp.databases.oracle.misc
Subject: Re: [student] BQFH
Date: Mon, 26 Oct 1998 19:00:37 GMT
Organization: XS4ALL, networking for the masses
Lines: 12
Message-ID: <3634c4e5.8360371@news.xs4all.nl>
References: <3634948b.39782966@news.m.iinet.net.au> <3634B935.616B54FE@uclink4.berkeley.edu>
Reply-To: martinj(replace this with @)xs4all.nl
X-XS4ALL-Date: Mon, 26 Oct 1998 20:00:26 CET
X-Newsreader: Forte Free Agent 1.11/32.235

....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
-------------------------------------------------------------------------------