Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

GROUP BY Extensions in MS SQL Server

Introduction
3. Get to know the tables – WildfireIncident
Summary

Instruction

Now, let’s take a look at the table that you’ll be querying in the exercises. It is named WildfireIncident and it contains the following columns:

  • Id – A unique identifier for each record/row in the table.
  • Year – The year when a given wildfire started: 2016, 2017, or 2018.
  • Month – The month when a given wildfire started: May, June, or July.
  • Cause – Lightning Strike, Arson, Spontaneous Combustion, or Unintentional Human Involvement.
  • DamageRepairCost – estimated cost to repair the damage caused by a given wildfire.
  • Duration – The number of hours a given wildfire lasted.

Exercise

Select all information from the WildfireIncident table.