>Thanks Sergey,
>Can you explain why you can't reference "sales_total" in the where clause even though it is a vaild column name?

The "sales_total" is column alias assigned with AS clause. It's SQL Server query parser limitation that column alias cannot be used in WHERE and some other clauses.