I am trying to rank an income/block group table with incomes between 0-10 as 1, between 11-20 as 2 and so on. I do not understand the issue with my query.

Query

The table I am working with

Thanks.