title: SQL ORDER BY multiple columns
body: <p>I want to sort my products table by two columns: <code>prod_price</code> and <code>prod_name</code>.</p>
  
  <pre><code>SELECT prod_id, prod_price, prod_name
  FROM Products
  ORDER BY prod_price, prod_name;
  </code></pre>
  
  <p>How is the sorting done here?  I think it happens first by <code>prod_price</code> and then by <code>prod_name</code>. Also, how is the above query different from this one:</p>
  
  <pre><code>SELECT prod_id, prod_price, prod_name
  FROM Products
  ORDER BY prod_name;
  </code></pre>
  
  <p>My products table is as follows:</p>
  
  <pre><code>CREATE TABLE Products
  (
    prod_id    char(10)      NOT NULL ,
    vend_id    char(10)      NOT NULL ,
    prod_name  char(255)     NOT NULL ,
    prod_price decimal(8,2)  NOT NULL ,
    prod_desc  text          NULL 
  );
  </code></pre>