hello, i'm using SQL - via Oracle Toad 12 and i need some help with my code.
i'm relatively new to SQL - i can do the most basic things, but this one is a little bit more complicated.
hoping someone can let me know what i'm doing wrong.

the inner SELECT statement works perfectly, but when i try to sum up the initial daily select statement into a monthly one i run into trouble