Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Get to know the tables – wildfire_incident
Summary

Instruction

Now, let’s take a look at the table that you’ll be querying in the exercises. It is named wildfire_incident 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.
  • damage_repair_cost – 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 wildfire_incident table.