SQL Operators Interview Questions

How does the NOT operator work in SQL?

From a products table (product_id, product_name, category, price, supplier_id), select products in categories 'Electronics', 'Appliances', or 'Gadgets' with prices between $100 and $500, supplied by suppliers 101, 102, or 103.

Is the BETWEEN operator inclusive or exclusive of boundary values?

From an employees table (emp_id, name, department, salary, city), find employees who work in 'IT' or 'Finance' departments, earn more than $50,000, but are NOT located in 'New York'.

What are the standard wildcard characters used with LIKE operator?

From a customers table (customer_id, first_name, last_name, email, phone), find customers whose first name starts with 'J', email contains 'gmail', and phone number ends with '123'.

What is the precedence order of logical operators in SQL?

How does BETWEEN operator work with date values?

How can multiple SQL operators be combined effectively?

From a orders table (order_id, customer_id, order_date, status, total_amount), find orders that are NOT in status 'Cancelled' or 'Refunded', have total amount between $50 and $200, and customer_id is NOT in the list (101, 102, 103).