Re: Help with simple SQL problem

select filmmaker_id, count(*) "Total" from film group by filmaker_id
having count(*) = (select
max(count(*)) from film
group by filmmaker_id)

steelx_at_hotmail.com wrote:

> I'm a newbie when it comes to databases and SQL. I'm now working with Oracle
> 7 and am messing around with tables to model a video shop. I've the
> following tables:
>
> FILM(film_no, film_name, filmmaker_id)
> FILM_MAKER(filmmaker_id, maker_name, maker_address)
>
> The filmmaker_id in FILM is a foreign key.
>
> The problem is, how do I find out the film maker that has the most films with
> the video shop?
>
> Note: I hope that this is the right place for me to ask questions like this.
> If it's not, please point me out to the appropriate newsgroup to ask. Also,
> I would really appreciate it if you CC your reply to steelx_at_hotmail.com
>
> Thanks in advance!
>
> El Ti
> steelx_at_hotmail.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri May 01 1998 - 12:45:20 CDT