Where again
When filtering strings, you need to wrap your value in 'single quotes', as you did in the previous exercise. You don't need to do this for numeric values, but you DO need to use single quotes for date columns.
In this course, dates are always represented in the YYYY-MM-DD format (Year-Month-Day), which is the default in Microsoft SQL Server.
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 nerc_region and demand_loss_mw
SELECT
___,
___
FROM
grid
-- Retrieve rows where affected_customers is >= 500000 (500,000)
___
___ ___ ___;