I have two Tables.
table A

```
id  name    Size
===================
1   Apple   7
2   Orange  15 
3   Banana  22
4   Kiwi    2
5   Melon   28
6   Peach   9

```

And Table B

```
id  size
==============
1   14
2   5 
3   31
4   9
5   1
6   16
7   7
8   25

```

My desired result will be (add one column to Table A, which is the number of rows in Table B that have **size** smaller than **Size** in Table A)

```
id  name    Size   Num.smaller.in.B
==============================
1   Apple   7      2
2   Orange  15     5
3   Banana  22     6
4   Kiwi    2      1
5   Melon   28     7
6   Peach   9      3  

```

Both Table A and B are pretty huge. Is there a clever way of doing this. Thanks