​In SQL, the **`HAVING`** and **`WHERE`** clauses are both used to impose a condition. However, `HAVING` is used to filter out results from *aggregated data*, whereas `WHERE` is used to add conditions to *individual rows*.

![](/api/edpresso/shot/4822674784124928/image/6343090992316416)

# Code

Suppose that we have the following tables:

**1. customer_details**
| **ID** | **Fname** |**Lname**|**Age**|
| ---------- | ------------ | --------------- | ------- | ------------------------- |
| 1          | Dan         |Phil| 35
| 2          | Hannah        | King| 28
| 3         |    Tim    | Brown| 40

**2. Order_details**

| **Cust_ID** | **Car** |**Price(millions)**|
| ---------- | ------------ | --------------- | ------- | ------------------------- |
| 3| Honda Civic| 4
| 1| Toyota Camry| 6
| 1| Ford Fiesta| 7
| 2|Audi A8| 50
| 3|  Ford Edge| 10

## Code using `HAVING` to find customer ID's with total purchase amount exceeding 13 million

SELECT Cust_ID, 
SUM(Price) AS Total 
FROM order_details
GROUP BY Cust_ID
HAVING total > 13

## Code using `WHERE` to find customers who are less than 40 years old

SELECT Fname, Lname 
FROM customer_details
WHERE Age < 40

HAVING vs. WHERE in SQL

HAVING filters aggregated data results; WHERE applies conditions to individual rows.

Cust_ID	Car	Price(millions)
3	Honda Civic	4
1	Toyota Camry	6
1	Ford Fiesta	7
2	Audi A8	50
3	Ford Edge	10

ID	Fname	Lname	Age
1	Dan	Phil	35
2	Hannah	King	28
3	Tim	Brown	40

HAVING vs. WHERE in SQL

Code

Code using HAVING to find customer ID’s with total purchase amount exceeding 13 million

Code using WHERE to find customers who are less than 40 years old

Code using `HAVING` to find customer ID’s with total purchase amount exceeding 13 million

Code using `WHERE` to find customers who are less than 40 years old