Month-to-Date (MTD) Sales vs. Sales Goal with SQL

This is a quick article about comparing month-to-date (MTD) sales from a sales database to a sales goal for use on it's own or with data visualization tools. This query assigns a goal of $1,000,000 as the sales goal for the month, adds up all sales for the month so far, and then compares it to where your sales should be at right now by showing 'Today's Target' so that that one can see at a glance if sales are on schedule. The results look like this:

Sales Goal  |  Today's Target  |  Gross Sales
​------------------------------------------------------
   1000000  |          515000          |  503000        

Read More