title: Word to code using SQL TeraData
body: <p>I have this question and don't know how to write the proper query to run this.</p>
  <blockquote>
  <p>Ohio has a large number of Dillard’s locations (21 in all). Ohio is also a large and diverse state. Each store naturally does a different volume of business and local customers demand different products.  While this allows local store managers to exercise their judgement about their own clientele, corporate management monitors the financial results at each store.</p>
  <p>Initially, the sales manager wants to rank the stores in Ohio from the lowest dollar volume of total sales to the highest during the year 2005. In your query, remember to include only Purchases (stype = ‘P’).</p>
  </blockquote>
  <p>I have this query that I have written but comes up with error 3707 which is Code =</p>
  <blockquote>
  <p>3707: Syntax error, expected something like a name or a Unicode
  delimited identifier between the word 'stype' and '='.</p>
  </blockquote>
  <p>What I have written is this</p>
  <pre><code>SELECT saledate, stype, amt, SUM(amt) AS “Total Dollar Volume” 
  FROM trnsact   
  WHERE state = 'OH' saledate BETWEEN '20050101AND '20051231'
  ORDER by sprice ASC
  </code></pre>
  <p>I am using the Teradata which my professor has provided.</p>