SELECT Done_vfp.column6, COUNT(Done_vfp.column7=="not"),;
  COUNT(Done_vfp.column7#"not");
 FROM ;
     done_vfp;
 GROUP BY Done_vfp.column6;
 ORDER BY Done_vfp.column6

SELECT s.column6, MAX(s.nonot) as nonot, MAX(s.not) as not;
    FROM (;
        SELECT a.column6, COUNT(a.column7) as nonot, MAX(CAST(0 as i)) as not;  
            FROM done_vfp a;  
            WHERE a.column7#"not";
            GROUP BY a.column6;
        UNION;  
        SELECT b.column6, MAX(CAST(0 as i)) as nonot, COUNT(b.column7) as not;  
            FROM done_vfp b;  
            WHERE b.column7=="not";
            GROUP BY b.column6;
    ) s;
    GROUP BY s.column6

SELECT ;
    Done_vfp.column6, ;
    SUM(IIF(Done_vfp.column7=="not", 1, 0)),;  
    SUM(IIF(Done_vfp.column7#"not", 1, 0)) ;  
FROM done_vfp ;  
GROUP BY Done_vfp.column6 ;  
ORDER BY Done_vfp.column6

SELECT Done_vfp.column6, SUM(IIF(Done_vfp.column7=="not", 1, 0)),;
    COUNT(IIF(Done_vfp.column7=="not", 0, 1)) ...

COUNT(*) - SUM(IIF(Done_vfp.column7=="not", 1, 0))