select distinct Sumit.City, Sumit.Name
from
(
select Row_Number() over(Partition By c.ID, c.City Order BY c.ID desc, City) as rowno,
c.ID, c.City, p.Name, p.PID
From Coupons c
JOIN Product p on c.pid = p.pid
) as Sumit
where Sumit.rowno = 1
1 assumption is that you use Sql Server by Microsoft