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!
Questo esercizio fa parte del corso
Introduction to SQL Server
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- 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;