Let's sort it!

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.

• Yes

• OK, let go!

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

SELECT ........ (........) ........, event_date FROM grid

........ ........ ........;

(a)  

Select the top 20 rows from description, nerc_region and event_date. Order by nerc_region, affected_customers & event_date. Event_date should be in descending order.

• SELECT

  TOP (20) PERCENT description, nerc_region, event_date

  FROM grid

  ORDER BY

  nerc_region,

  affected_customers,

  event_date DESC;

• SELECT

  TOP (20) description, nerc_region, event_date

  FROM grid

  ORDER BY

  nerc_region,

  affected_customers,

  event_date DESC;

• SELECT

  TOP (20) description, nerc_region, event_date

  FROM grid

  ORDER

  nerc_region,

  affected_customers,

  event_date DESC;

• SELECT

  TOP (20) description, nerc_region, event_date

  FROM grid

  ORDER BY

  nerc_region,

  affected_customers,

  event_date;

• Select the description and event_year columns. Return rows where the description is 'Paris'.

SELECT ......., ....... FROM grid WHERE ....... = 'Paris';

(a)  

• Select the nerc_region and demand_loss_mw columns, limiting the results to those where affected_customers is greater than or equal to 500000.

SELECT ......., ....... FROM grid WHERE ....... >= 500000;

(a)  

• Update your code to select description and affected_customers, returning records where the event_date was the 22nd December, 2023.

SELECT nerc_region, demand_loss_mw FROM grid

WHERE affected_customers >= 500000;

(a)  

• Fill in the blank

• Limit the results to those where the affected_customers is BETWEEN 50000 and 150000.

SELECT description, affected_customers, event_date FROM grid

WHERE (a)   ;

• Fill in the blank

• Order in descending order of event_date.

SELECT description, affected_customers, event_date FROM grid

WHERE affected_customers BETWEEN 50000 AND 150000

(a)   ;

• Use a shortcut to select all columns from grid table. Then filter the results to only include rows where demand_loss_mw is unknown or missing.

SELECT ......... FROM grid WHERE ...........

(a)  

• Adapt your code to return rows where demand_loss_mw is not unknown or missing.

SELECT * FROM grid WHERE demand_loss_mw IS NULL;

(a)