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.
Questo esercizio fa parte del corso
Introduction to SQL Server
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Select nerc_region and demand_loss_mw
SELECT
___,
___
FROM
grid
-- Retrieve rows where affected_customers is >= 500000 (500,000)
___
___ ___ ___;