Specific Column is not showing up, when it should?
<p>I don't know what's going on with my code here.  I am trying to return the highest number of calls received by particular phone numbers, and find the top 7 numbers by calls received, but I am only getting the count column in my results.  The code is:</p>

<pre><code>SELECT COUNT (call_id) FROM call_test
GROUP BY receiver_id
ORDER BY COUNT(call_id) DESC
LIMIT 7;
</code></pre>

<p>But all it is returning is:</p>

<pre><code>COUNT(call_id)
3
2
2
2
2
1
1
</code></pre>

<p>I think my code is right, but how do you show the particular numbers that correspond to the respective counts?  This is SQLPro for MAC.</p>