Question $41$

SELECT $\_($please fill in this blank$)$

FROM Agent A$,$ Branch B

WHERE A$.$Branch$\_$ID $=$B$.$Branch$\_$ID

Agent$\_$LName, Agent$\_$HireDate, IF$($Branch$\_$State$=\text{'}$PA$\text{'},$'Yankee!$\text{'},$ IF$($Branch$\_$State$=\text{'}$MD$\text{'},$'Southerner!$\text{'}))$ as 'location'

Agent$\_$LName, Agent$\_$HireDate, 'Yankee!$\text{'}$

FROM Agent A$,$ Branch B

WHERE A$.$Branch$\_$ID$=$B$.$Branch$\_$ID

UNION

SELECT Agent$\_$LName, Agent$\_$HireDate, 'Southerner!$\text{'}$ as 'location'

Agent$\_$LName, Agent$\_$HireDate, IF$($Branch$\_$State$=\text{'}$PA$",$Yankee!$\text{'},$'Southerner!$\text{'})$ as 'location'

Agent$\_$LName, Agent$\_$HireDate, 'Yankee!$\text{'}$

FROM Agent A$,$ Branch B

WHERE A$.$Branch$\_$ID $=$B$.$Branch$\_$ID

AND Branch$\_$State$=\text{'}$PA$\text{'}$

UNION

SELECT Agent$\_$LName, Agent$\_$HireDate, 'Southerner!$\text{'}$ as 'location'

Agent$\_$LName, Agent$\_$HireDate, IF$($Branch$\_$State$=\text{'}$PA$\text{'},$'Yankee!$\text{'}),$ IF$($Branch$\_$State$=\text{'}$MD$\text{'},$Southerner!$\text{'})$