MySQL HAVING: Examples

Examples
Sample Database

#1

SELECT 
    ordernumber,
    SUM(quantityOrdered) AS itemsCount,
    SUM(quantityOrdered*priceeach) AS total
FROM
    orderdetails
GROUP BY ordernumber;

#2

SELECT 
    ordernumber,
    SUM(quantityOrdered) AS itemsCount,
    SUM(quantityOrdered*priceeach) AS total
FROM
    orderdetails
GROUP BY ordernumber
HAVING total > 1000;

#3

SELECT 
    ordernumber,
    SUM(quantityOrdered) AS itemsCount,
    SUM(quantityOrdered*priceeach) AS total
FROM
    orderdetails
GROUP BY ordernumber
HAVING total > 1000 AND itemsCount > 600;

#4

SELECT 
    a.ordernumber, status, SUM(priceeach*quantityOrdered) total
FROM
    orderdetails a
        INNER JOIN
    orders b ON b.ordernumber = a.ordernumber
GROUP BY ordernumber, status
HAVING status = 'Shipped' AND total > 1500;

Table List

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

offices

SELECT * FROM offices;

orderdetails

SELECT * FROM orderdetails;

orders

SELECT * FROM orders;

payments

SELECT * FROM payments;

productlines

SELECT * FROM productlines;

products

SELECT * FROM products;

Result