Font size
Worksheets4-mavzu. SELECT operatori va WHERE filtrlari
Total questions: 17
Worksheet time: 11mins
Quyidagi so‘rov employees jadvalidan faqat first_name va salary ustunlarini chiqaradi:
SELECT _______
FROM employees;
*
first_name, salary
salary AND first_name
all
employees jadvalidan faqat 30 yoshdan katta xodimlarni chiqarish uchun qaysi so‘rov to‘g‘ri?
SELECT * FROM employees WHERE age < 30;
SELECT * FROM employees WHERE age >= 30;
SELECT * FROM employees WHERE age > 30;
SELECT * FROM employees;
Ismi "A" harfi bilan boshlanadigan xodimlarni chiqarish uchun qaysi so‘rov to‘g‘ri?
SELECT * FROM employees WHERE first_name LIKE '%A';
SELECT * FROM employees WHERE first_name LIKE 'A%';
SELECT * FROM employees WHERE first_name LIKE '_A%';
SELECT * FROM employees WHERE first_name = 'A';
Telefon raqami kiritilmagan xodimlarni chiqarish uchun qaysi so‘rov ishlatiladi?
SELECT * FROM employees WHERE phone IS NULL;
SELECT * FROM employees WHERE phone = NULL;
SELECT * FROM employees WHERE phone == NULL;
SELECT * FROM employees WHERE phone LIKE NULL;
Yoshi 25 dan katta va maoshi 1500 dan yuqori bo‘lgan xodimlarni chiqarish uchun qaysi so‘rov to‘g‘ri?
SELECT * FROM employees WHERE age > 25 AND salary > 1500;
SELECT * FROM employees WHERE age > 25 OR salary > 1500;
SELECT * FROM employees WHERE age < 25 AND salary > 1500;
SELECT * FROM employees WHERE age > 25;
SELECT DISTINCT department_id FROM employees;
Quyidagi so‘rov nima qiladi?
Barcha ustunlarni chiqaradi
Faqat department_id ustunini chiqaradi, takroriy qiymatlar olib tashlanadi
department_id ustunini o‘chiradi
department_id ustunidagi qiymatlarni ko‘paytiradi
Quyidagi so‘rovda qaysi ism(lar) chiqadi?
SELECT * FROM students WHERE name LIKE '%bek';
Bek, Abek, Sirojbek
Bekzod, Bekjon
Umidbek, Sirojbek, Ulug‘bek
Bekir, Bektemir
Quyidagi so‘rov nima qiladi?
SELECT * FROM products WHERE product_name LIKE '_a%';
Ikkinchi harfi “a” bo‘lgan mahsulotlarni chiqaradi
Birinchi harfi “a” bo‘lgan mahsulotlarni chiqaradi
“a” bilan tugagan mahsulotlarni chiqaradi
“a” harfi bo‘lmagan mahsulotlarni chiqaradi
Quyidagi so‘rov nima qiladi?
SELECT * FROM employees WHERE salary BETWEEN 1000 AND 2000;
Oyligi 1000 dan kichiklarni chiqaradi
Oyligi 2000 dan kattalarni chiqaradi
Oyligi 1000 va 2000 oralig‘ida bo‘lganlarni chiqaradi (1000 va 2000 ham kiradi)
Faqat 1000 va 2000 bo‘lganlarni chiqaradi
Quyidagi so‘rov nima qiladi?
SELECT * FROM products WHERE price BETWEEN 500 AND 500;
Faqat narxi 500 bo‘lgan mahsulotlarni chiqaradi
Hech qanday natija bermaydi
Narxi 500 dan katta mahsulotlarni chiqaradi
500 dan 1000 gacha narxlarni chiqaradi
Quyidagi so‘rov qaysi xodimlarni chiqaradi?
SELECT * FROM employees WHERE salary BETWEEN 2000 AND 4000;
Oyligi 1500 bo‘lgan xodimlar
Oyligi 2000 bo‘lgan xodimlar
Oyligi 3500 bo‘lgan xodimlar
Oyligi 4000 bo‘lgan xodimlar
Oyligi 4500 bo‘lgan xodimlar
Quyidagi shart qaysi ismlarni chiqaradi?
WHERE first_name LIKE 'A%'
Ali
Anvar
Dilshoda
Karima
Quyidagi so‘rovda qaysi mahsulotlar chiqadi?
WHERE product_name LIKE '_a%'
Baraka
Samokat
Alifbo
Tablet
Lola
Quyidagi shart qaysi talabalarning guruhini chiqaradi?
WHERE group_id IN (101, 103, 105)
Guruh 101 dagilar
Guruh 102 dagilar
Guruh 103 dagilar
Guruh 104 dagilar
Guruh 105 dagilar
Quyidagi shart qaysi xodimlarni chiqaradi?
WHERE department = 'IT' OR department = 'HR'
IT bo‘limidagilar
HR bo‘limidagilar
Marketing bo‘limidagilar
Accounting bo‘limidagilar
2 * 3 = 12
2 * 4 = 16
3 * 5 = 30
4 * 5 = ?
(a)
Tushirib qoldirilgan sonni aniqlang.
9
7
8
11
