title: Trying to divide two counts in SQL
body: <p>so I'm trying to do simple division and of course SQL, being super logical that it is, makes it impossible. What I am trying to do is this:</p>
  
  <pre><code>SELECT * FROM 
  1 - ((SELECT COUNT(DISTINCT T.DID) FROM TGAMAZING T AS NUM) * 100 /
  (SELECT COUNT(DISTINCT D.ID) FROM DIRECTORS D AS DENOM))
  </code></pre>
  
  <p>but how would I write this SQL (Oracle)?</p>