Hello, I am just starting to teach myself some stuff about sql and writing queries to better analyze data. I have created the following data below and I am practicing some query writing when I began to have a problem with 'case' and 'min'. What I am trying to do is to look at each Continent then grab the smallest population value from a country in that Continent with an 'Emerging' status. This is column 'mine'. What I have noticed is that it is not giving me the minimum. For example South America is not giving me 30 from Chile but instead the 250 from Brazil. Can someone help me fix this. Thanks. h ttp://i.imgur.com/lys2twx.png?1 please remove the space as I just joined I can't post links.