SQL · Question 22 · Medium

SQL question 22

Table Orders:
order_id | customer | city | amount
101 | Meera | Chennai | 1200
102 | Arjun | Bengaluru | 600
103 | Meera | Chennai | NULL
104 | Sana | Delhi | 1100
105 | Arjun | Bengaluru | 600
106 | Dev | Bhopal | 300
107 | Sana | Delhi | 400

What does this query return?

SELECT COUNT(*)
FROM Orders
WHERE amount BETWEEN 400 AND 1100;
  1. 2
  2. 3
  3. 5
  4. 4
Answer and explanation

Answer: D. 4

Explanation: BETWEEN is inclusive at both ends, so 600, 1100, 600 and 400 qualify. 1200 and 300 are outside the range, and the NULL amount gives UNKNOWN, so it is not counted. The result is 4.

Previous: Table Orders: order_id | customer | city | amount 101 | Meera | Chennai | 1200… · Next: Table Orders: order_id | customer | city | amount 101 | Meera | Chennai | 1200…

Practise sql

Try a fresh set of sql questions with an explanation after every answer, free and without signing up: SQL practice. Or sit a full placement mock test.

More sql questions

More technical & programming practice

Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming · Java

LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge