Select unique records from multiple records based on max date
For the first condition 


count() Over (Partition by id, addr, Ind)
max(update_date) Over (Partition by id, addr, Ind) 


For the secontd condition 


row_number Over (Partition by id, addr, Ind and update_Date)