Double Rows coming in Report for Single Employee who have been assigned Same Course Multiple times

Content

Hi, 
I have attached a Query where Single Employee who have been assigned Course "2000_Make Our Customers Love Landmark_L&G_BFL" multiple times by Same Admin/Different Admin is appearing multiple times in the query(all effective dated conditions are properly done, to get active row). 
For example: 
HRMS id 143658 has two rows one "In Progress" another "Pending Active". 
The Assigned By is by two different Learn Admin. 
Where as in the frontend 1 row is showing i.e "In Progress" 
Please suggest what should be done to get the rows in the Query as its coming in Frontend.