Ciro Santilli @cirosantilli 37

sqlite3 tmp.sqlite 'create table t(x integer)'
sqlite3 tmp.sqlite <<EOF
insert into t values (
  0,
  2,
  2,
  3,

  5,
  6,
  6,
  8,
  9,

  17,
)
EOF
sqlite3 tmp.sqlite 'create index tx on t(x)'

sqlite3 tmp.sqlite <<EOF
select floor(x/5)*5 as x,
       count(*) as cnt
from t
group by 1
order by 1
EOF

0|4
5|5
15|1

sqlite3 tmp.sqlite <<EOF
select x, sum(cnt) from (
  select floor(x/5)*5 as x,
         count(*) as cnt
    from t
    group by 1
  union
  select *, 0 as cnt from generate_series(0, 15, 5)
)
group by x
EOF

0|4
5|5
10|0
15|1

sqlite3 db.sqlite3 "
CREATE TABLE 'IntegerNames' (int0 INT, char0 CHAR(16));
INSERT INTO 'IntegerNames' (int0, char0) VALUES (2, 'two'), (3, 'three'), (5, 'five'), (7, 'seven');
"

sqlite3 db.sqlite3 '.tables'

IntegerNames

sqlite3 db.sqlite3 '.schema IntegerNames'

CREATE TABLE IF NOT EXISTS 'IntegerNames' (int0 INT, char0 CHAR(16));

sqlite3 db.sqlite3 'SELECT * FROM IntegerNames'

2|two
3|three
5|five
7|seven