title: BigQuery SQL: percent with 2 decimal places
body: <p>In BigQuery standard SQL, I need to present a result of division as <strong>percentage with 2 decimal places, e.g. 21.23%</strong>.
  The only way I've been able to achieve this is by the doing the following:</p>
  
  <ol>
  <li><code>ROUND</code> the result to 2 decimal places</li>
  <li><code>CAST</code> it as a string</li>
  <li><code>FORMAT</code> to add the percent character</li>
  </ol>
  
  <p><code>FORMAT('%s%%', CAST(ROUND((val_1 / val_2) * 100, 2) AS STRING))</code></p>
  
  <p>It feels like a workaround... </p>
  
  <p><strong>Is there a proper way of doing it?</strong> 
  Primarily, I'd like to keep the output as a float, not a string. </p>
  
  <p>Thanks!</p>