What nurses are on call with block floor 1 and block code 1? Tell me their names.
CREATE TABLE on_call (nurse VARCHAR, blockfloor VARCHAR, blockcode VARCHAR)
[SQL] SELECT nurse FROM on_call WHERE blockfloor = 1 AND blockcode = 1 [/SQL]