Why does the following query fail to list all of the students who have taken$/$are taking a course

taught by Dr$.$ Brandt? $(5$ points$)$

$\backslash$Pi student.name, student.ID $($student $$ takes $$ teaches $\backslash$sigma name $=$Brandt$($instructor$))$