/86400.00 as duration) dr;"</span>)
</pre>
</div>
<p>
And now how it would be written in s-sql
</p>
<div class="org-src-container">
<pre class="src src-lisp">(query
 (<span class="org-builtin">:select</span> 'pledged-usd 'avg-pledge-usd 'amt-from-goal 'duration
          (<span class="org-builtin">:as</span> (<span class="org-builtin">:/</span> 'usd-from-goal 'duration) 'usd-needed-daily)
          <span class="org-builtin">:from</span> 'kickstarter-data
          <span class="org-builtin">:lateral</span> (