title: SQL adding 2 query's to make one
body: <p>This is the data I'm working with in my SQL database:</p>
  <pre><code>Symbol | Close_Below
    AAPL       1        
    TSLA       0                
    AAPl       0
    AAPL       1        
    SPY        0                
    TSLA       1      
    SPY        0                
    AAPL       1 
  </code></pre>
  <p>SQL Query I'm using to count how many times a symbol is in the database:</p>
  <pre><code>SELECT Symbol, count(*) as SymbolCount FROM data GROUP BY Symbol;
  </code></pre>
  <p>Output:</p>
  <pre><code>Symbol | SymbolCount 
    AAPL       4        
    TSLA       2                
    SPY        2
  </code></pre>
  <p>Another SQL Query I'm using to sum all the 1's for each symbol:</p>
  <pre><code>SELECT  Symbol, SUM(Close_Below) as Close_Below_Sum FROM data GROUP BY Symbol;
  </code></pre>
  <p>Output:</p>
  <pre><code>Symbol | Close_Below_Sum 
    AAPL        3        
    TSLA        1                
    SPY         0
  </code></pre>
  <p><strong>How would you go about getting the query to show the percentage of how many 1's to the symbol count for each symbol?</strong> Example below.</p>
  <p>Desired Output:</p>
  <pre><code>Symbol | Perc
    AAPL    0.75        
    TSLA    0.50                
    SPY     0.00
  </code></pre>