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
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
____;