Suppose I have the following two tables (formatted as Excel tables):
StateData:
PresidentData:
How do I sort the PresidentData table by the population of the state in which they were born?
StateData:
State Abbreviation | State Name | Population |
AL | Alabama | 4,903,185 |
AK | Alaska | 710,249 |
AZ | Arizona | 7,278,717 |
AR | Arkansas | 3,017,804 |
PresidentData:
LastName | Birthplace (State Abbreviation) |
Trump | NY |
Obama | HI |
Bush | CT |
How do I sort the PresidentData table by the population of the state in which they were born?