Cacher is the code snippet organizer for pro developers

select count(*) from tiger_grid_us where average_v<1  --result = 11

select count(*) from tiger_grid_us where average_v>=1 AND average_v<1.2  --result = 281037

select count(*) from tiger_grid_us where average_v>=1.2 AND average_v<1.5 --result = 62177

select count(*) from tiger_grid_us where average_v>=1.5 AND average_v<1.7 --result = 32127

select count(*) from tiger_grid_us where average_v>=1.7 AND average_v<1.9 --result = 14016

select count(*) from tiger_grid_us where average_v>=1.9 --result = 46493