Hi Zahid,
I think the following query will solve your problem.

SELECT FID, CNAME FROM ATTENDED WHERE FID IN (SELECT FID FROM ATTENDED HAVING COUNT(FID)=1 GROUP BY FID);
Bye....