title: Incorrect syntax in SQL query near '('
body: <p>I believe the problem is near the <code>(</code> next to <code>quoted price</code> as I get a syntax error of <code>Incorrect syntax near '('</code>.  Any help with this would be greatly appreciated.  Using Microsoft SQL-Server Management Studio.</p>
  
  <pre class="lang-sql prettyprint-override"><code>create view order_total as
  
  select order_num
  
  sum (quoted_price * num_ordered) as total_amount
  
  from order_line;
  </code></pre>