Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. Get to know the tables – WildfireIncident


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.
  • CauseLightning 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.


Select all information from the WildfireIncident table.