MySQL Getting two different total amounts based on criteria

[jmyrtle]

I went with Option 3. It seems the easiest and quickest way. See my previous response.