Resolving Duplicate Records in SQL Queries: A Comprehensive Guide to Window Functions and Table Joins