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.
Deze oefening maakt deel uit van de cursus
Introduction to SQL Server
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select the first 20 rows from the specified columns
SELECT
___ (___) ___,
event_date
FROM
grid
-- Order your results by the event_date column
____;