consider the following database for a summer camp:

Camper$($cid$,$ name$)$

Team$($gid$,$ age$)$

Assignment$($cid$,$ gid$)$

table Assignment captures the assignments of campers to teams. Primary keys:

Camper$-$ cid, Team$-$gid, Assignment$-$cid, gid

Is the query below correct for returning the name of all campers who have not yet been assigned to a team:

select C$.$nam

from Camper C$,$ Assignment A

where C$.$cid$<>$A$.$cid