4.5 IN, BETWEEN and LIKE (% and _) with Real Filters

By Ravindra Bagale Last updated: 31 October 2026

Why. Lists, ranges and patterns cover most analyst filters.

What. IN lists values. BETWEEN is inclusive range. LIKE uses % (any) and _ (one char).

How. WHERE city IN ('Pune','Mumbai') / amount BETWEEN 500 AND 900 / name LIKE 'A%'

Steps

Example 1 · dataset: raja_coffee

SELECT order_id, city, amount_inr
FROM orders
WHERE city IN ('Pune','Goa')
  AND amount_inr BETWEEN 600 AND 1000;

Output

Meaning. Pune or Goa, mid-size amounts.

Example 2 · dataset: raja_coffee

SELECT name, city FROM customers WHERE name LIKE 'P%';

Output

name	city
Priya Deshmukh	Kolhapur

Meaning. Names starting with P (Priya pattern).

Ravindra Bagale's Tip

BETWEEN is inclusive on both ends — 600 and 1000 both qualify.