how to get the earlier date in SQL?

[waely]

Add an and condition to the where clause and perfrom a sub query to get the Min(date).

don't I need to write some kind of IF condition checking for multiple country value then get the earlier date?

I attached a table showing my example. the result should have all countries but min date if douplicate country. please check out and advise.



thank you