Answer
The second lowest frequency at which resonance occurs is $~~1506~Hz$
Work Step by Step
We can find the resonant frequencies of the pipe:
$f = \frac{nv}{2L}$, where $n = 1,2,3,...$
$f = \frac{(n)(344~m/s)}{(2)(0.457~m)}$, where $n = 1,2,3,...$
$f = 376~Hz, 753~Hz, 1129~Hz, 1506~Hz, 1881~Hz, 2258~Hz,...$
The second lowest frequency (between $1000~Hz$ and $2000~Hz$) at which resonance occurs is $~~1506~Hz$