create table elements (
    position      int8,
    start_value   int8,
    end_value     int8
);

##</code><code>##

select position from element where end_value >= 50000 and start_value <= 1000000;