sqlite> select avg(loves), (select name from users order by rowid asc) from posts where poster=(select id from users order by rowid asc);
┌──────────────────┬─────────────────────────────────────────────┐
│    avg(loves)    │ (select name from users order by rowid asc) │
├──────────────────┼─────────────────────────────────────────────┤
│ 15.5070422535211 │ jeffalo                                     │
└──────────────────┴─────────────────────────────────────────────┘

aw come on