How can i get the male count and female count seperately : here is my code `public function getmaletofemaleCountById()
	{
         $select=$this->select();
        $select->from($this->_name, array('count(*) AS candidateSum','count(candidate_gender='.MALE.') AS male','count(candidate_gender='.FEMALE.') AS female'));
        $select->joinLeft(array('batch'=>DBPREFIX.'batch'), 'batch.batch_training_center=tc_id AND batch.deleted=0', array());
        $select->joinLeft(array('candidate'=>DBPREFIX.'candidate'), 'candidate.candidate_batch_id=batch.batch_id AND candidate.deleted=0', array());
        $select->where( 'tc_id = ?',$this->tc_id);
        $select->where( 'candidate_gender != ?',3);
        //$select->group('candidate_gender');
       die($select);
   
        return $this->fetchRow($select);
        }`