The view high_earners uses a limit of 1,50,000. Change it to use 1,00,000 instead (same columns).
high_earners
Run your code to see the output here.