1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to SQL Server

Exercise

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.

Instructions

100 XP
  • 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.