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.
Latihan ini adalah bagian dari kursus
Introduction to SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Select nerc_region and demand_loss_mw
SELECT
___,
___
FROM
grid
-- Retrieve rows where affected_customers is >= 500000 (500,000)
___
___ ___ ___;