Rozenshtein question 1 (sql cookbook)

really bizzare solutions in the book

here is the simple answer to find any student not taking a particular course

select * from student s

where not exists

(

select * from take t

where t.cno = 'CS112'

and t.sno = s.sno

)