MIN, MAX and AVG
Along with summing and counting, you'll frequently need to find the minimum, maximum, and average of column values. Thankfully, T-SQL has functions you can use to make the task easier!
Latihan ini adalah bagian dari kursus
Introduction to SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Find the minimum number of affected customers
SELECT
___(affected_customers) AS ___
FROM
grid
-- Only retrieve rows where demand_loss_mw has a value
WHERE
___ ___ ___ NULL;