Hi Sorry for the confusion.
The distinct values for F1 is only 1, 2 and 3, so the distinct value count is 3. However, there are totally 6 records that have duplicate F1 values. The task 2 is to calculate the total count of conflict records so it is 6. Hope that explain the issue clearly. Thanks > > You start explaining that because the distinct values are only 1, 2, 3, the > 'total > count' should be 3. Then on the next line, you say wanting to get the 'total > count' and say it should be 6. You lost me between those lines. :) > > -- > Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier > Mascia, integral.be/om >