title: Calculating Conversion Rate In MySQL
body: <p>I'm trying to calculate the conversion rate of clicks and unique visitors for local analytic part of a website. MySQL 5.1.73, appears to not like my query. I'm not sure if the sources I'm getting are using deprecated syntax, or I'm simply not asking the correct question in Google.</p>
  
  <pre><code>SELECT 
      (SUM(click1) DIV SUM(unique) * 100) /* &lt;&lt;&lt;&lt; Synrax Error Here */
  FROM
      stats_clicks
  WHERE
  aid = 10050 AND
  timestamp_local BETWEEN '2014/01/01' AND '2015/12/01'
  </code></pre>
  
  <p>Sorry if this is a very beginner-isk question. A lot of my resources are not working in this case.</p>