>When it comes to those specific SQL Server syntaxes, combined with DISTINCT, it is then getting a little far from what I do on a regular basis. Maybe one day I will have a little bit more time to read some documentation on those topics and move forward into those advanced queries.

Yes, DISTINCT as parameter to SUM, AVG, and COUNT is often overlooked but can greatly simplify some queries.