我有一个MariaDB查询，在数据库查询中运行良好。

SELECT student_id, last_name, first_name , Count(id) as courses FROM registrations
WHERE student_id NOT IN (SELECT student_id FROM exclude_from_tracking_list)
GROUP BY student_id
HAVING COUNT(*) > 3
ORDER BY last_name

但是不能在Laravel 8中运行。

DB::statement('with query')

DB::table('registrations') 
        ->selectRaw('student_id, last_name, first_name , Count(id) as courses')
        ->where(DB::raw('student_id NOT IN (SELECT student_id FROM exclude_from_tracking_list'))    
        ->groupBy('student_id')
        ->havingRaw('COUNT(*) > 3')
        ->orderBy('last_name')
        ->get();

我错过了什么。我已经搜索并尝试了许多其他选项。
但我一直收到这个错误
数据库状态[42000]：语法错误或访问冲突：1064 0x 0064您的SQL语法有错误;检查与您的MariaDB服务器版本对应的手册，以获得正确的语法，在第1行使用near 'is null group by student_id having COUNT（）〉3 order by last_name asc'（SQL：select student_id，last_name，first_name，Count（id）as courses from registrations where student_id NOT IN（SELECT student_id FROM exclude_from_tracking_list is null group by student_id having COUNT（）〉3 order by last_name asc）
任何帮助都将不胜感激。