SQL Query for Calculating Daily, Monthly, Yearly, and Group Totals from an Existing Table

Conditional Calculations in SQL: Using Case Statements to Create New Fields Based on Results of Another Field