title: How to make a fake column with an autoincrement number in a "group by" query
body: <p>I have data in a table like this:</p>
  
  <pre><code> fgid   qty   ntid
   1      100   10
   2      90    10
   6      200   11
   1      80    11
   1      120   12
   6      100   12
   6      30    13
  </code></pre>
  
  <p>And i make query :</p>
  
  <pre><code>SELECT fgid, SUM(qty) AS total_qty, COUNT(ntid) AS nt_count FROM sofg 
  GROUP BY fgid
  </code></pre>
  
  <p>AND the result is :</p>
  
  <pre><code> fgid   total_qty   nt_count
   1      300         3
   2      90          1
   6      330         3
  </code></pre>
  
  <p><strong>Then i want to make the result like this</strong> :</p>
  
  <pre><code>no    fgid    total_qty   nt_count
  1     1       300         3
  2     2       90          1
  3     6       330         3
  </code></pre>
  
  <p><strong>How to do that with a query?</strong> where '<strong>no</strong>' is (like) autoincrement number.</p>