I am Giving You Two Options

Below are the three SQLs just adding to a table

The one above I summarized the dollar fields!