In awk (and nawk) abc is a variable name and since you haven't assigned anything to that variables, its contents is an empty string (if a string is expected) or zero (if a number is expected). ...
Having assumed that
- you being an sql developer as explained in post#1 NOT posting homework questions
- the original headers of both files shall be eliminated
- the 1 trailing in output line 2...