SELECT *
FROM Universities
WHERE Students BETWEEN 10000 AND 30000

SELECT *
FROM Universities
WHERE Students > 10000 AND Students < 30000

SELECT *
FROM Universities
WHERE Students >= 10000 AND Students <= 30000

SELECT 
<Сложное выражение 1>, 
<Сложное выражение 2>
FROM XX
WHERE <Сложное выражение 1> >= <Сложное выражение 2> AND <Сложное выражение 1> >= 1 AND <Сложное выражение 2> <= 99999

declare @t table (id int primary key, a float);

set statistics profile on;
select id, a from @t where power(a, 3) between 5 and 10 or power(a, 3) between 15 and 20;
select t.id, t.a from @t t cross apply (select power(t.a, 3)) x(a3) where x.a3 between 5 and 10 or x.a3 between 15 and 20;
with t as (select top (cast(0x7fffffffffffffff as bigint)) id, a, power(a, 3) as a3 from @t order by id) select id, a from t where a3 between 5 and 10 or a3 between 15 and 20;
set statistics profile off;

set statistics profile on;
SELECT y, SIN(y) FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(0)) x(y)
WHERE SIN(y) > 0.1 AND SIN(y) < 0.9 
set statistics profile off;