Get startedGet started for free

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.

This exercise is part of the course

Introduction to SQL Server

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Select the first 20 rows from the specified columns
SELECT 
  ___ (___) ___, 
  event_date 
FROM 
  grid 
  -- Order your results by the event_date column
____;
Edit and Run Code