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 Member Posts: 1
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

Comments

  • Chris BrownChris Brown USAMember Posts: 4,496 ✭✭

    _______ || http://forcoder.org || free video tutorials and ebooks about // C++, PHP, C, Visual Basic, Python, Objective-C, PL/SQL, Delphi, MATLAB, Scratch, R, Visual Basic .NET, Ruby, Go, Perl, JavaScript, Swift, C#, Assembly, Java COBOL, Logo, F#, Crystal, SAS, Bash, Julia, Prolog, Lisp, Erlang, D, ML, VBScript, Hack, Scala, LabVIEW, Dart, Apex, FoxPro, Kotlin, Awk, Lua, ABAP, Fortran, Alice, Scheme, Rust, Transact-SQL, Clojure, Ada // _

Sign In or Register to comment.