SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table users (
  id int,
  name varchar(20),
  exp int
);
✓
insert into users values
(1, 'test', 270),
(2, 'foo', 510);
✓
create table levels (
  level int,
  exp int
);
✓
insert into levels values
(1, 0),
(2, 100),
(3, 250),
(4, 500);
✓
SELECT u.*, max(l.level) as level
from users u
inner join levels l on u.exp >= l.exp
group by u.id




id
name
exp
level


1
test
270
3

2
foo
510
4