อยากขอ code sql ในการเรียงลำดับข้อมูลจากฐานข้อมูลค่ะ รบกวนทีนะคะ

 <?
$page = $_GET['page'];

$select_type="select DISTINCT usermem  from playgame  order by win desc";
$query_select=mysql_query($select_type);
$num_rows=mysql_num_rows($query_select);

if($num_rows<1){
echo "<br><br><center><font color=#666666 face=tahoma size=2><b>ยังไม่มีการเพิ่มข้อมูลค่ะ</b></font></center>";
}else{
		$select="select  DISTINCT usermem  from playgame  order by win desc";
		$q_ry = mysql_query($select);
	 	$num_rows=mysql_num_rows($q_ry);
  		$pagesize=5;
		$rt=$num_rows%$pagesize;
		if($rt!=0)
			{
				$totalpage=floor($num_rows/$pagesize)+1;
			}
		else
			{
				$totalpage=floor($num_rows/$pagesize);
				$toppic_id=1;
			}
		if(empty($page))
			{
				$page=1;
			}
		mysql_free_result($q_ry);
		$goto=($page-1)*$pagesize;
$sql_select_mem="Select  DISTINCT usermem From playgame  order by win desc limit $goto,$pagesize";
		$fect=mysql_query($sql_select_mem);
		if(!$fect)
		{
		("ติดต่อฐานข้อมูลไม่ได้".mysql_error());
		exit;
		}

	  $bgcount=0;
	while($rows=mysql_fetch_array($fect))
	{
$idpg =$rows['id'];
$usermemberplay = $rows['usermem'];

$bgcount=$bgcount+1;
$bgmod=$bgcount%2;
if($bgmod==0){
	$bgcolor="#DFD5A9";
}else{
	$bgcolor="#BBF1E0";
}
	?>

select usermem,
sum(CASE resultgame 
WHEN 'win' THEN 1
else 0
END) AS win ,
sum(CASE resultgame 
WHEN 'lost' THEN 1
else 0
END) AS lost 
from game group by usermem desc