select * from tbl_riskassessments where assessmentname not in (select assessmentname from tbl_riskassessments where date IS NOT NULL)




select * from tbl_riskassessments where assessmentname not in (select assessmentname from tbl_riskassessments where date IS NULL)