title: MySQL - Using COUNT(*) outside the SELECT
body: <p>I have this data and I want to return the names of customers in descending order of their count</p>
  
  <pre><code>Customer | Count
  abc      | 2
  efg      | 3
  hij      | 7
  klm      | 3
  </code></pre>
  
  <p>So for the table above the result should be </p>
  
  <pre><code>Customer
  hij
  efg
  klm
  abc
  </code></pre>
  
  <p>I have this query</p>
  
  <pre><code>Select Customer, Count(*) AS CustomerCount
  From 'customers'
  group by Customer
  order by CustomerCount DESC
  </code></pre>
  
  <p>which gives me</p>
  
  <pre><code>Customer | Count
  hij      | 7
  efg      | 3
  klm      | 3
  abc      | 2
  </code></pre>
  
  <p>But I don't want to display the count and I don't know how to do that. Can anybody help me?</p>