Does anyone have a SQL for population and population growth

I was trying to make a SQL for population and population growth that shows how many civilians are born every year by all colonies combined