José Amílcar Ferreira Casimiro (@jafcasimiro) has given you one solution.
Here is a good CodeProject article for you to understand joins better
Visual Representation of SQL Joins[
^]
And here is another one to help you understand how subqueries work:
SQL Server: Subqueries[
^]
A couple of other points ...
a) you try to query on columns
b.amount
and
h.amount
but neither table has such a column name.
b) Avoid using "Reserved Words" for column names - for example
date
and
name
. If you do use them then remember to surround them with square brackets to distinguish between the column name and the type (or other reserved word).