Application of subtracting numerical values ​​in different tables

Question

I have two tables:

Table A
ID Number Profile
1 100 Baker
2 75 Fields
3 100 Wayward

Table B
ID Number Tag Sender
1 50 on chris
2 50 off james

I am trying to subtract values ​​with the same ID number from table A and table B

Table C
ID Number
1 50
2 25

Answer 1

SELECT A.ID,A.NUMBER-B.NUMBER DIFF
FROM TABLE_A AS A
JOIN TABLE_B AS B ON A.ID=B.ID