aggregating max date over two different ref_id containing same license_no.

[Dinesh_123]

Here, primary key is ref_id having similar license_no against it . Each ref_id has different date due to update in license now i want to show max date(created on date can be seen in above snip) for license_no.

for e.g. ref_id 1,2,3 have license_no LIC001 and has 3 different created on date against each ref_id now i want to show max date among these  in front of all 3 ref_ids. 

like 1/1/2022, 1/2/2022, 1/3/2022 , ref_id 1,2,3 to show max date as 1/3/2022 against its license_no.