1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to SQL Server

Exercise

Order by

In this exercise, you'll practice the use of ORDER BY using the grid dataset. It's loaded and waiting for you! It contains a subset of wider publicly available information on US power outages.

Some of the main columns include:

  • description: The reason/ cause of the outage.
  • nerc_region: The North American Electricity Reliability Corporation was formed to ensure the reliability of the grid and comprises several regional entities.
  • demand_loss_mw: How much energy was not transmitted/consumed during the outage.

Instructions 1/2

undefined XP
  • 1

    Select description and event_date from grid. Your query should return the first 5 rows, ordered by event_date.

  • 2

    Modify your code based on the comments provided on the right.