I have a SQLite table that looks like this:

```
   ID_TABLE          POINTS_A_TABLE       POINTS_B_TABLE
  id   number       id_a   points_a      id_b   points_b
--------------     ----------------     ----------------
 smith   1         smith     11         smith      25
 gordon  22        gordon    11         gordon     NULL
 butch   3         butch     11         butch      26
 sparrow 25        sparrow   NULL       sparrow    44
 white   76        white     46         white      NULL

```

With the following command

```
SELECT id,
       avg(points_a)
FROM (SELECT id_a AS id, points_a FROM points_a_table
      UNION ALL
      SELECT id_b AS id, points_b FROM points_b_table)
GROUP BY id
ORDER BY avg(points_a) DESC;

```

i'm able to get the average of points associated with each name ([more details here](https://stackoverflow.com/questions/44770409/average-by-rows-with-sqlite/44776403?noredirect=1#comment76555345_44776403))

```
 id    avg(points_a)
white     46.0  [(46+0)/2]
sparrow   44.0  [(0+44)/2]
butch     18.5  [(11+26)/2]
smith     18.0  [(11+25)/2]
gordon    11.0  [(11+0)/2]

```

Now I'd like to **match the resulting column `id` with the corresponding column`number` in `ID_TABLE` with ID\_TABLE.number LESS THAN 26**. The result should be (`number|average`): 

 ~~76 46.0 [(46+0)/2]~~ 

```
25    44.0  [(0+44)/2]
3     18.5  [(11+26)/2]
76    18.0  [(11+25)/2]
22    11.0  [(11+0)/2]

```

How can I do that **all in one query**, by **combining** new instructions with the previous ones ?