sqlite3_playground.sql

create table scores(id smallint primary key, score smallint not null);

CREATE INDEX score_idx ON scores (score);


WITH RECURSIVE
  cnt(x) AS (
     SELECT 1
     UNION ALL
     SELECT x+1 FROM cnt
      LIMIT 10000
  ) 
  insert into scores(id, score) select x, random() from cnt;


select count(*) from scores where score <= 2673474448148295663;