title: How can I understand the ORDER BY clause in the below mentioned SQL query?
body: <p>I was doing an assignment where I did not get this SQL query right. The question was:</p>
  
  <blockquote>
    <p>Excluding $0.00, what is the minimum bi-weekly high rate of pay (please include the dollar sign and decimal point in your answer)?</p>
  </blockquote>
  
  <p>What I did:</p>
  
  <pre><code>Select 
  MIN(Biweekly_high_Rate)
  FROM salary_range_by_job_classification
  WHERE MIN(Biweekly_high_rate)&gt;0;
  </code></pre>
  
  <p>But this gave me answer as 0. And 0 isn't the correct answer
   Then I looked at the solution. And I didn't understand the last line of solution</p>
  
  <pre><code>Select Biweekly_high_Rate
  From salary_range_by_job_classification
  ORDER BY LENGTH(Biweekly_high_Rate) ASC, Biweekly_high_Rate ASC;
  </code></pre>
  
  <p>How can I understand the ORDER BY statement?</p>