Unfortunately there's no way to really create temp tables or to set user-defined variables in this platform there is a way however where you could mimic this logic by let's say creating a faux CTE. How so? Easy...
With t1 as(
select 1+1)
select 235 as threshold from t1
This could also be a subquery depending on where you want to go but this way you can join it you can cross join it and then filter on it but it gives you a couple of options as opposed to the non-existent ones