This is my code. I am trying to find the number of distinct students teacher number 288 has.
SELECT COUNT (STU_NUM) AS Result
FROM (SELECT DISTINCT STU_NUM FROM ENROLL INNER JOIN CLASS ON ENROLL.CLASS_CODE = CLASS.CLASS_CODE) AS InnerSelect
WHERE EMP_NUM = 228;
When I run that code I get an 'Enter Parameter Value' error asking me to enter an EMP_NUM.
What am I doing wrong!?!
SELECT COUNT (STU_NUM) AS Result
FROM (SELECT DISTINCT STU_NUM FROM ENROLL INNER JOIN CLASS ON ENROLL.CLASS_CODE = CLASS.CLASS_CODE) AS InnerSelect
WHERE EMP_NUM = 228;
When I run that code I get an 'Enter Parameter Value' error asking me to enter an EMP_NUM.
What am I doing wrong!?!
