 What are the name and primarily affiliated department name of each physician?
CREATE TABLE department (
    departmentid number,
    name text,
    head number
)

CREATE TABLE block (
    blockfloor number,
    blockcode number
)

CREATE TABLE undergoes (
    patient number,
    procedures number,
    stay number,
    dateundergoes time,
    physician number,
    assistingnurse number
)

CREATE TABLE on_call (
    nurse number,
    blockfloor number,
    blockcode number,
    oncallstart time,
    oncallend time
)

CREATE TABLE nurse (
    employeeid number,
    name text,
    position text,
    registered boolean,
    ssn number
)

CREATE TABLE stay (
    stayid number,
    patient number,
    room number,
    staystart time,
    stayend time
)

CREATE TABLE trained_in (
    physician number,
    treatment number,
    certificationdate time,
    certificationexpires time
)

CREATE TABLE physician (
    employeeid number,
    name text,
    position text,
    ssn number
)

CREATE TABLE room (
    roomnumber number,
    roomtype text,
    blockfloor number,
    blockcode number,
    unavailable boolean
)

CREATE TABLE appointment (
    appointmentid number,
    patient number,
    prepnurse number,
    physician number,
    start time,
    end time,
    examinationroom text
)

CREATE TABLE patient (
    ssn number,
    name text,
    address text,
    phone text,
    insuranceid number,
    pcp number
)

CREATE TABLE medication (
    code number,
    name text,
    brand text,
    description text
)

CREATE TABLE procedures (
    code number,
    name text,
    cost number
)

CREATE TABLE prescribes (
    physician number,
    patient number,
    medication number,
    date time,
    appointment number,
    dose text
)

CREATE TABLE affiliated_with (
    physician number,
    department number,
    primaryaffiliation boolean
)
SELECT T1.name, T3.name FROM physician AS T1 JOIN affiliated_with AS T2 ON T1.employeeid = T2.physician JOIN department AS T3 ON T2.department = T3.departmentid WHERE T2.primaryaffiliation = 1