Having standart so‘zi orqali so‘rovlar yaratish

HAVING standart so‘zi orqali so‘rovlar yaratish.
HAVING operatori GROUP BY operatori bilan birgalikda guruhlar uchun asosan agregat funksiya natijalariga shart berish orqali cheklovlar o’rnatish uchun ishlatiladi. HAVING operatori sintaksisi quyidagicha:
SELECT
select_list
FROM
table_name
WHERE
search_condition
GROUP BY
group_by_expression
HAVING
group_condition;
Bu sintaksisda GROUP BY orqali hosil qilngan satrlar, group_condition o’rnida berilgan shart rost qiymat qabul qilganda natijaviy jadvalga kiritiladi. HAVING operatori bajarilish tartibi:

SELECT product, SUM(quantity) AS "Total quantity"
FROM order_details
GROUP BY product
HAVING SUM(quantity) > 10;

SELECT
ordernumber,

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

SELECT
ordernumber,

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