SQL HAVING

List all countries with more than 2 suppliers.

SELECT Country, COUNT(Id) AS Suppliers
  FROM Supplier
 GROUP BY Country
HAVING COUNT(Id) > 2

HAVING syntax.

SELECT column-names
  FROM table-name
 WHERE condition
 GROUP BY column-names
HAVING condition

HAVING syntax with ORDER BY.

SELECT column-names
  FROM table-name
 WHERE condition
 GROUP BY column-names
HAVING condition
 ORDER BY column-names

SELECT Country, COUNT(Id) AS Customers
  FROM Customer
 GROUP BY Country
HAVING COUNT(Id) > 10

SELECT Country, COUNT(Id) AS Customers
  FROM Customer
 WHERE Country <> 'USA'
 GROUP BY Country
HAVING COUNT(Id) >= 9
 ORDER BY COUNT(Id) DESC

SELECT FirstName, LastName, 
       CONVERT(DECIMAL(10,2), AVG(TotalAmount)) AS 'Average  Order'
  FROM [Order] O 
  JOIN Customer C ON O.CustomerId = C.Id
 GROUP BY FirstName, LastName
HAVING AVG(TotalAmount) BETWEEN 1000 AND 1200

Note: CONVERT formats the average value to 2 decimals.

• Our Sql WHERE Tutorial
• Our Sql GROUP BY Tutorial
• Our Sql CONVERT Function Reference