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 SQL

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.
  • cause – Lightning 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.