SELECT physician, department FROM affiliated_with WHERE primaryaffiliation = 1
Sebutkan ID karyawan dokter bersama dengan ID departemen afiliasi utama mereka.
CREATE TABLE affiliated_with (physician VARCHAR, department VARCHAR, primaryaffiliation VARCHAR)