I wondered how I could create a query to return rows where the base population is smaller than other countries , but the population_growth rate is at a percent fast enough that more people are added than the country with the larger population. Ideally I could have a condition where I return all those smaller countries which overtake the larger within 10 years.
I have just done complex queries in intermediate sql and thought I might be able to create two views, but do not know what of in this situation since I think I need to compare the population column to itself and also the growth_rate at the same time . I thought I might need UNION and the set operator EXCEPT but that is as far as I can get. Please advise?