@prakash : hope u understand ashuthinks requirement
as per ashuthinks requirement i generate some sample data and generate the result. as he didn't provide any DDL and sample data, max we can assume only :hehe:
he asked for country and region for region where india and iran belongs to, so bascially as per my data he is asking for asia region's country name and region.
got it 😎