title: What is the simplest way in SQL to determine a ratio(1:1) from a generated result?
body: <p>I'm very new to SQL and from what I've been told the solution to my query is a simple line or two of code.  Basically, I have a database of individual profiles that includes name, favorite book, political leanings and others.  I was provided with a code cell that determines percentages and lift - see below:</p>
  <p><img src="https://i.stack.imgur.com/NbUNE.png" alt="code" /></p>
  <p>and result:</p>
  <p><img src="https://i.stack.imgur.com/skdXi.png" alt="result" /></p>
  <p>Basically I just want to narrow the results down to instances where the perc_con and perc_libs are within a range of .8-1.2:.8-1.2 i.e 1:1.</p>
  <p>I hope that makes sense.</p>
  <p>Thanks!</p>