Why is the count 7? How do the fields match up? On the numeric values in your first table and the matching part in the second table?
Could there also be values in the second table:
and the second value there get counted too? or is the text part always the same?
What have you tried so far?
Do you understand how UNION and UNION ALL work and are different from each other?
Also for your date columns it looks like you are using a varchar/char field type, why not use them as DATE types?