title: greater than a certain number sql
body: <p>I need to make an sql query that will show the following:</p>
  
  <p>'Total number of active accounts that are more than 90 days old as of the current date'</p>
  
  <p>The date is coming from an sql query which is this:</p>
  
  <pre><code>select date from currentdatetable
  </code></pre>
  
  <p>Now my query is to count all active accounts that come from the accountstable so my query goes like this:</p>
  
  <pre><code>select count(*) from accountstable
  </code></pre>
  
  <p>My problem is how do I state that the date from the accountstable is greater than 90 days old than the date of the currentdatetable?</p>
  
  <p>My current code:</p>
  
  <pre><code>select count(*) from accountstable at where at.date &gt; (select date from currentdatetable)
  </code></pre>