title: put order by in right place mysql
body: <p>i have query like this </p>
  
  <pre><code>SELECT COALESCE(p.name, 'total') AS `product name`, 
         SUM(omd.quantity) AS `Qty(kg)`,
         SUM(omd.quantity) / any_value(total_sum) * 100 AS `Qty(%)`, 
         COUNT(om.id) AS `COunt Order`,
         COUNT(om.id) / any_value(total_count) * 100 AS `Count Order(%)`
  FROM order_match om
  INNER JOIN order_match_detail omd
  ON om.id = omd.order_match_id
  INNER JOIN product p
  on omd.product_id = p.id
  INNER JOIN (select SUM(omd1.quantity) total_sum,
          count(om1.id) total_count
      FROM order_match om1
      INNER JOIN 
      order_match_detail omd1
      ON om1.id = omd1.order_match_id
      where om1.order_status_id in 
      (4, 5, 6, 8)) totals
      where om.order_status_id in (4, 5, 6, 8)
      group by p.name with rollup;
  </code></pre>
  
  <p>and after running that query the result was this (this is just dummy)</p>
  
  <pre><code>+--------------+---------+--------+-------------+-----------------+
  | Product Name | Qty(kg) | Qty(%) | COunt Order | Count Order (%) |
  +--------------+---------+--------+-------------+-----------------+
  | Product A    |      20 |     20 |          10 |              10 |
  | Product B    |      30 |     30 |          10 |              10 |
  | Product C    |      45 |     45 |          30 |              30 |
  | Product D    |       5 |      5 |          50 |              50 |
  | TOtal        |     100 |    100 |         100 |             100 |
  +--------------+---------+--------+-------------+-----------------+
  </code></pre>
  
  <p>i want to put <code>order by</code> and order based on the Qty(kg)</p>
  
  <p>the expected result was this</p>
  
  <pre><code> +--------------+---------+--------+-------------+-----------------+
  | Product Name | Qty(kg) | Qty(%) | COunt Order | Count Order (%) |
  +--------------+---------+--------+-------------+-----------------+
  | Product C    |      45 |     45 |          30 |              30 |
  | Product B    |      30 |     30 |          10 |              10 |
  | Product A    |      20 |     20 |          10 |              10 |
  | Product D    |       5 |      5 |          50 |              50 |
  | TOtal        |     100 |    100 |         100 |             100 |
  +--------------+---------+--------+-------------+-----------------+
  </code></pre>
  
  <p>so this is my query after i put order by</p>
  
  <pre><code>SELECT COALESCE(p.name, 'total') AS `product name`, 
         SUM(omd.quantity) AS `Qty(kg)`,
         SUM(omd.quantity) / any_value(total_sum) * 100 AS `Qty(%)`, 
         COUNT(om.id) AS `COunt Order`,
         COUNT(om.id) / any_value(total_count) * 100 AS `Count Order(%)`
  FROM order_match om
  INNER JOIN order_match_detail omd
  ON om.id = omd.order_match_id
  INNER JOIN product p
  on omd.product_id = p.id
  INNER JOIN (select SUM(omd1.quantity) total_sum,
          count(om1.id) total_count
      FROM order_match om1
      INNER JOIN 
      order_match_detail omd1
      ON om1.id = omd1.order_match_id
      where om1.order_status_id in 
      (4, 5, 6, 8)) totals
      where om.order_status_id in (4, 5, 6, 8)
      group by p.name with rollup
      order by omd.quantity DESC;
  </code></pre>
  
  <p>but after i run it, the notification just like this</p>
  
  <pre><code>Error COde :1221. Incorrect usage of CUBE/R0LLUP and ORDER BY
  </code></pre>
  
  <p>so which part i should edit or add so it can be ordered by what i want</p>