Direction: Choose the correct option
Q1.
SELECT * FROM employees WHERE department IN ('IT', 'HR', 'Finance');What does IN operator do?Direction: Choose the correct option
Q2.
SELECT * FROM products WHERE price BETWEEN 100 AND 500;What range does BETWEEN include?Direction: Choose the correct option
Q3.
SELECT * FROM customers WHERE name LIKE 'A%';What does '%' represent in LIKE?Direction: Choose the correct option
Q4.
SELECT * FROM customers WHERE email LIKE '%@gmail.com';Which emails will this find?Direction: Choose the correct option
Q5.
SELECT * FROM employees WHERE manager_id IS NULL;What does IS NULL check for?