OraFAQ Forum: Server Administration » How to query this question?

Home » RDBMS Server » Server Administration » How to query this question?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to query this question? [message #373853]

Tue, 15 May 2001 22:27

Steve
Messages: 190
Registered: September 1999

Senior Member

Hi,ALL:
I would like to make a query from these sample tables for a dummy insurance company.
The tables are as follows.
1. Person(pid,fname,lname,bdate,street,suburb,state,postcode)
2. Client(pid,cid)
3. Insured_by(cid,pno)
4. Policy(pno,pname,status,startdate,expirydate,id)
5. Insured_Item(id,brand,model,year,reg)
My question: List the most popular car models insured in specified suburb(that is, cars whose owners live in that suburb. For one policy there may be more than one holders)

Thanks for you help.
Steve

Report message to a moderator

Previous Topic:	How to use count function to count insurance policy which more than one person hold?
Next Topic:	procedure creates the insert statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 17:12:40 CDT 2024