title: The BETWEEN operator cannot be used with a subquery; however, the BETWEEN operator can be used within the subquery
body: <p>I am unable to understand following rule of subquery..can anyone please help me in understanding this with example if possible...</p>
  
  <pre><code>"The BETWEEN operator cannot be used with a subquery; however, the BETWEEN operator can be used within the subquery"
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/lnToy.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lnToy.jpg" alt="enter image description here"></a></p>