Home » RDBMS Server » Server Administration » How to query this question?
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
|
|
|
Goto Forum:
Current Time: Thu Apr 10 19:51:45 CDT 2025
|