I have a table with data from a golfcourse (pars), and I have a user who has recorded several of scores for this golfcourse. Now what I want to do is to figure out how man par3, 4 and 5 holes he has played...

To make this example easy I have merged everything down to 3 holes, but normally it would be 18 holes.

The golfcourse table looks like this:
(courseid,hole1,hole2,hole3)

The course record:
1,3,4,4

Now the score table:
(userid,courseid,hole1,hole2,hole3)

Now the user has forexample 3 records like this:
1,1,5,4,5
1,1,3,4,4
1,1,4,3,4


Now what I want to do is get an output like this:
# of par 3: 3
# of par 4: 6
# of par 5: 0


I just don't know how to acomplish this...

Any help is apreciated...

Thanks in advance :-)