SELECT  Hwsv.year,Hwsv.scode,Hwsv.lcode,Hwsv.sec, Hwsv.perc,COUNT(*)as nowork,;
  Student.sex;
 FROM ;
     student ;
 left JOIN hwsv ;
   ON  Student.code = Hwsv.code;
    WHERE  Hwsv.year=thisform.year.value AND hwsv.scode=thisform.scoDE.Value and Hwsv.perc<50 AND student.admtd=1 AND student.joind<CTOD("20/06/2010") ;
              ORDER BY hwsv.lcode;
              GROUP BY hwsv.lcode,hwsv.sec;
              INTO cursor nowork
  
 brows
    SELECT Hwsv.year,Hwsv.scode,Hwsv.lcode,Hwsv.sec, Hwsv.perc,COUNT(*) as completee,;
  Student.sex;
 FROM ;
     student ;
 left    JOIN hwsv ;
   ON  Student.code = Hwsv.code;
    WHERE  Hwsv.year=thisform.year.value AND hwsv.scode=thisform.scoDE.Value AND Hwsv.perc =100 and student.admtd=1 AND student.joind<CTOD("20/06/2010");
              GROUP BY hwsv.lcode,hwsv.sec;
       ORDER BY hwsv.lcode;
             INTO cursor com
                 brows
      
      
      
       SELECT Hwsv.year,Hwsv.scode,Hwsv.lcode,Hwsv.sec, Hwsv.perc,COUNT(*) as incompl ,;
  Student.sex;
 FROM ;
     student ;
    left JOIN hwsv ;
   ON  Student.code = Hwsv.code;
    WHERE  Hwsv.year=thisform.year.value AND hwsv.scode=thisform.scoDE.Value AND Hwsv.perc <100 and Hwsv.perc>49 AND student.admtd=1 AND student.joind<CTOD("20/06/2010");
              GROUP BY hwsv.lcode,hwsv.sec;
       ORDER BY hwsv.lcode;
       INTO CURSOR incom


SELECT Com.*, Incom.*, Nowork.*;
 FROM ;
     com ;
   LEFT JOIN incom ;
   ON  Com.scode = Incom.scode;
   AND  Com.lcode = Incom.lcode;
   AND  Com.sec = Incom.sec ;
    left JOIN nowork ;
   ON  Com.scode = Nowork.scode;
   AND  Incom.lcode = Nowork.lcode;
   AND  Incom.sec = Nowork.sec;
       INTO CURSOR  ghu10cc