What are the name and primarily affiliated department name of each physician?
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
name of each physician refers to T1.name; primarily affiliated department name refers to T3.name; JOIN is used to combine rows from two or more tables based on a related column between them; WHERE clause is used to filter records that fulfill a specified condition; PrimaryAffiliation = 1 indicates the filter for primarily affiliated departments.