Get startedGet started for free

Having

WHERE is used to filter rows before any grouping occurs. Once you have performed a grouping operation, you may want to further restrict the number of rows returned. This is a job for HAVING. In this exercise, you will modify an existing query to use HAVING, so that only those results with a sum of over 10000 are returned.

This exercise is part of the course

Introduction to SQL Server

View Course

Exercise instructions

  • Modify the provided query to remove the WHERE clause.
  • Replace it with a HAVING clause so that only results with a total demand_loss_mw of greater than 10000 are returned.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
  nerc_region, 
  SUM (demand_loss_mw) AS demand_loss 
FROM 
  grid 
  -- Remove the WHERE clause
WHERE demand_loss_mw  IS NOT NULL
GROUP BY 
  nerc_region 
  -- Enter a new HAVING clause so that the sum of demand_loss_mw is greater than 10000
___ 
  ___(demand_loss_mw) > ___ 
ORDER BY 
  demand_loss DESC;
Edit and Run Code