Just a day ago, I was was asked this question in one of the teaching session to my team members. One of the member asked me if I can use DISTINCT in Aggregate Function and does it make any difference.
Of course! It does make difference. DISTINCT can be used to return unique rows from a result set and it can be used to force unique column values within an aggregate function.
SELECT SUM(DISTINCT ReorderPoint) ResultDistinct
SELECT SUM(ReorderPoint) ResultNoDistinct
Reference : Pinal Dave (https://blog.sqlauthority.com)