尝试此查询

SELECT stu_Name,result
    FROM `marks`
    WHERE stu_D not in
    (SELECT stu_D FROM marks WHERE  result='FAILED')
    GROUP BY stu_D

SELECT 
   T.stu_D, T.stuName, IF(T.number_of_failures>0, 'FAILED', 'PASSED') final_result
FROM
(SELECT 
   stu_D, stuName, COUNT(IF(result='FAILED', 1, NULL)) number_of_failures
 FROM your_table
 GROUP BY stu_D, stuName) T;

你可以试试下面的查询-

SELECT stu_D
   ,stuName
   ,CASE 
    WHEN T2.CNT = 0 
         THEN 'passed' 
         ELSE 'failed' 
    END status 
FROM (SELECT stu_D
            ,stuName
            ,COUNT(CASE
                   WHEN result = 'FAILED' 
                       THEN 1
                   END) CNT
     FROM T
     GROUP BY stu_D
             ,stuname) T2