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
0 · ·