Tekshirilayotgan ifoda between quyi ifoda and yuqori ifoda not

(-------- WHERE ----------- SHART -----------------)
(--- NOT ---)
(-------- AND -------------------------)
(-------- OR --------------------------)
Bu operatorlar yordamida yaratilgan bir necha so‘rovlarni ko‘rib chiqamiz.
Masalan: Sotuvlari xaqiqiy xajmi rejadagidan yoki $300.00 dan kam bo‘lgan xizmatchilarni aniqlash
SELECT NAME, QUOTA, SALES
FROM SALESREPS
WHERE SALES < QUOTA OR SALES < 300.0
Sotuvlari xaqiqiy xajmi rejadagidan va $300.00 dan kam bo‘lgan xizmatchilarni aniqlash
SELECT NAME, QUOTA, SALES
FROM SALESREPS
WHERE SALES < QUOTA AND SALES < 300.0
Sotuvlari xaqiqiy xajmi rejadagidan kam, lekin $150.00 dan ko‘p bo‘lgan xizmatchilarni aniqlash
SELECT NAME, QUOTA, SALES
FROM SALESREPS
WHERE (SALES < QUOTA) AND (NOT SALES > 150.000)
AND ifodasi algebrasi.
Qiymat Natija
-------------- ----------