Help with simple SQL problem

From: <steelx_at_hotmail.com>
Date: Thu, 30 Apr 1998 12:55:38 -0600
Message-ID: <6iaduq$3bd$1@nnrp1.dejanews.com>

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 Thu Apr 30 1998 - 13:55:38 CDT