title: Mysql query(same) returns different result order with different result set
body: <p>I am naive to Mysql world....:)i was trying to query from the tables using joins,</p>
  
  <p>where i encountered  a problem with the result set...and the table structure are as </p>
  
  <p>below...</p>
  
  <pre><code>VIDEO_XXXXX
  
  | Field         | Type          | Null | Key | Default           | Extra                       |
  | VIDEO_ID      | int(255)         
  | TAG_NAME      | varchar(1000)
  | SHOP_ID       | varchar(100)   FK
  | LOVES          | int(255)      
  | VIDEO_URL     | varchar(1000) 
  | UPLOADED_DATE | 
  
  
  PLACE_TABLE...
  
   SHOP_ID       | varchar(100) PK
  </code></pre>
  
  <p>The Query Looks like..</p>
  
  <pre><code>   SELECT V.SHOP_ID
       FROM VIDEO_xxxx V  
       JOIN STUB_xxxx_TABLE S  ON S.SHOP_ID=V.SHOP_ID
      WHERE S.COUPON_STATUS='REDEEMED' 
   GROUP BY V.SHOP_ID 
   ORDER BY COUNT(S.COUPON_GENERATED_ID) DESC;
  </code></pre>
  
  <p>The result set as follows...</p>
  
  <pre><code>+-----------+
  | SHOP_ID   |
  +-----------+
  | 001       |
  | 004       |
  | 005       |
  | 003       |
  | 002       |
  </code></pre>
  
  <p>The second query is....</p>
  
  <pre><code>   SELECT V.SHOP_ID
       FROM SECOND_TABLE V  
       JOIN STUB_xxxx_TABLE S  ON S.SHOP_ID=V.SHOP_ID  
      WHERE S.COUPON_STATUS='REDEEMED'
   GROUP BY V.SHOP_ID 
   ORDER BY COUNT(S.COUPON_GENERATED_ID) DESC;
  </code></pre>
  
  <p>And the result set is...</p>
  
  <pre><code>+--------+
  | SHOP_ID|
  +--------+
  |001     |
  |004     |
  |003     |
  |002     |
   005     |
  </code></pre>
  
  <p>I wonder why the order of shop_id shuffles....:( :( any help will be appreciated...:), </p>