Untitled

How can I select a Distinct value and then order by amount returned using mysql and PHP?
<?php
$query_db = ("SELECT DISTINCT SGSID FROM SGresult WHERE SGFACemail = '$email'");
$result = mysql_query($query_db, $surveys) or die(mysql_error());


$i = 0;
while ($row = mysql_fetch_assoc($result)) {

$SGSID = $row['SGSID'];
//INSERTED MODIFIED SELECT STATEMENT HERE
$query_check = ("SELECT SGpID, count(*) AS numCount FROM SGresult WHERE SGFACemail = '$email' AND  SGSID = '$SGSID' GROUP BY SGpID");

$result_c = mysql_query($query_check, $surveys) or die(mysql_error());
$row2 = mysql_fetch_array($result_c);
$SGpID = $row2[3];
echo $row2['numCount'];

//tried num_rows statement to return value of numCount
//$num_rows2 = mysql_num_rows($result_c, $row2['numCount']);
$num_rows = mysql_num_rows($result_c);

$query_name = ("SELECT * FROM SGsurveyID WHERE SGSID = '$SGSID'");


$result_F = mysql_query($query_name, $surveys) or die(mysql_error($surveys));
$name_row = mysql_fetch_row($result_F);

<?php echo $row2['numCount'];  //this returns results, but not the amount of rows
  $i++;?>

  <tr>
        <td><?php echo $i;?></td>
        <td><?php echo $name_row[1];?></td>
        <td><?php echo $num_rows;  ?></td>
        <td> <?php echo $row2['numCount']; ?></td>
      </tr>
      <?php


}

SELECT SGpID
  , count(*) AS numCount
FROM SGresult
WHERE SGFACemail = '$email'
  AND  SGSID = '$SGSID'
GROUP BY SGpID
ORDER BY numCount desc