MySQL中存储过程stored procedure中报错，END这里画浪线啊

Question

新人一枚~END这里画浪线啊，说有语法错误啊！
抓狂了，求各位牛人帮忙查一下！谢谢~
DELIMITER $$
DROP PROCEDURE IF EXISTS `unusedClassroom` $$
CREATE PROCEDURE `unusedClassroom`()
DETERMINISTIC
BEGIN
SELECT * FROM classroom 
WHERE cl_id NOT IN(
SELECT Course.cl_id 
FROM Course 
WHERE week >=4  
UNION
SELECT ClassroomBorrow.cl_id 
FROM ClassroomBorrow 
WHERE week >=4 )
END $$
DELIMITER ; 

Answer 1

sql结束要加;SELECT * FROM classroom  
WHERE cl_id NOT IN
(
SELECT Course.cl_id  FROM Course  WHERE week >=4   
UNION
SELECT ClassroomBorrow.cl_id  FROM ClassroomBorrow  WHERE week >=4 
);
END

Answer 2

DELIMITER $$
DROP PROCEDURE IF EXISTS `unusedClassroom` $$
CREATE PROCEDURE `unusedClassroom`()
DETERMINISTIC
BEGIN
SELECT * FROM classroom  
WHERE cl_id NOT IN(
SELECT Course.cl_id  
FROM Course  
WHERE week >=4 
UNION
SELECT ClassroomBorrow.cl_id  
FROM ClassroomBorrow  
WHERE week >=4 
);
END $$
DELIMITER ;