จะสามารถเขียนโค๊ด SQL สั้น ๆ ทีเดียวการหาค่าต่ำสุดและสูงสุดได้หรือไม่ครับ???

$sqlMinMaxAndAvg = "SELECT IFNULL(MIN(`reqYQ`) ,0) AS MinimumYQ "
."      ,IFNULL(AVG(`reqYQ`) ,0) AS AverageYQ "  
."      ,IFNULL(MAX(`reqYQ`) ,0) AS MaximumYQ "
."FROM tb_userreq ; " ;

$resultSet = mysql_query( $sqlMinMaxAndAvg ) ;

<?php
class mydb
{
   function createCommand($s){
      $this->_query = $s;
      return $this;
   }
   function queryScalar($param=array()){
      $result = mysql_query($this->_query);
      return mysql_result($result,0);
   }
}

$d = new mydb;
$max = $d->createCommand("SELECT Max(*) FROM tb")->queryScalar();
$min = $d->createCommand("SELECT Min(*) FROM tb")->queryScalar();

?>

$sqlMinMaxAndAvg = "SELECT IFNULL(MIN(`reqYQ`) ,0) AS MinimumYQ "
."      ,IFNULL(AVG(`reqYQ`) ,0) AS AverageYQ "  
."      ,IFNULL(MAX(`reqYQ`) ,0) AS MaximumYQ "
."FROM tb_userreq ; " ;

$resultSet = mysql_query( $sqlMinMaxAndAvg ) ;