title: SQLite syntax for operator “ANY”
body: <p>I'm trying execute this query in SQLite:</p>
  
  <pre><code>SELECT *
  FROM customers 
  WHERE rating = ANY
        (SELECT rating
         FROM customers
         WHERE city = 'Rome');
  </code></pre>
  
  <p>But received this error:</p>
  
  <pre><code>Query Error: near "SELECT": syntax error Unable to execute statement
  </code></pre>
  
  <p>If I replace 
      <code>rating = ANY</code>
   to <code>rating IN</code>, everything works fine.</p>
  
  <p>Can someone show me how <strong>ANY</strong> statement works in SQLite and what I am doing wrong?</p>