I have two tables called DONOR (key DONOR_ID) and DONATION (DONATION_ID). They are connected via DONOR_ID.
Now I want to count how many Donors(uniqe DONOR_ID) that have exactly 2 donations(DONATION_ID).
How do i achieve this?
Sounds like you should be able to do something like this:
Count all instance where the number of donation-id's = 2, for every Donor_id and assign them the value 1. Then sum up these ones into the total count.
Thank you, worked perfect!
Please have a look at this post - maybe you have a solution?
Retrieving data ...