title: How to use sqrt function in sqlite query in android
body: <p>I have this code:</p>
  <pre class="lang-kotlin prettyprint-override"><code>// select all venues where distance to theme is less than 1km
  @Query(&quot;SELECT * FROM Venue WHERE SQRT(((lat-:lat)*(lat-:lat))+((lng-:lng)*(lng-:lng)))&lt;1000.0 ORDER BY distance LIMIT 30 OFFSET :offset&quot;)
  fun getVenues(lat: Double, lng: Double, offset: Int): Flow&lt;List&lt;Venue&gt;&gt;
  
  </code></pre>
  <p>But I'm facing this error:</p>
  <pre><code>2021-02-23 00:38:51.419 30376-30510 E/SQLiteLog: (1) no such function: SQRT
  </code></pre>
  <p>what should I do for using SQRT in android sqlite?</p>