How do I code the PASS or FAIL using the case when statement when sum the total?
If score is 46, then pass. If equal or less than 45, then fail.
sum(qa.scripting1+qa.conduct1+qa.conduct2+qa.conduct3) as CScore,
--Fail??
sum(qa.scripting1+qa.conduct1+qa.conduct2+qa.conduct3)/46 as CPASS