Queries please help - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Queries please help

carpcarp Posts: 1Member
Hi out there:

I've got following tables:

MEMBERSHIP(membership-no, cover-type, start-date, end-date)
PERSON(person-no, surname, initials, membership-no)
DOCTOR(doctor-no, surname, initials, address)
PROVIDED-SERVICE(person-no, doctor-no, service-date, service-no)
REBATE(service-no, cover-type, refund)
SERVICE(service-no, service-name, service-description)

And I need to solve this querie :

What are the surnames, initials, membership-nos and cover-types of those persons who were provided more than the average number of unique services provided to persons in the month of March, 2002?

I have no idea how I could solve this maybe someone could help me, please.........

Thanks a lot

carp
Sign In or Register to comment.