how to convert this raw sql to eloquent

Hi guys,

SELECT *
FROM students
WHERE 
EXISTS (SELECT * FROM enrollments AS EN WHERE EN.student_id=students.id)
and 
students.id NOT IN (
    SELECT DISTINCT student_id FROM enrollments where batch_id IS NOT NULL
);

How can we convert this into eloquent

tykus

3 years ago

Best Answer

Level 104

Student::has('enrollments')
    ->whereNotIn(
        'id',
        Enrollment::select('student_id')->distinct()->whereNotNull('batch_id')
    )
    ->get();

1 like

umairparacha

3 years ago

Level 7

@tykus Thanks

Please or to participate in this conversation.