A.
The data architect loads two copies of the Employees table, aliases the appropriate fields, and aliases the CustID field when loading the Customers table.

B.
The data architect aliases the MrgID field to RegionalAcctMgrID and the CustID field in the Customers table

C.
The data architect performs two Left Joins to the Sales table to get the Employee names and loads the Customers table aliasing the CustID field.

D.
The data architect performs three Left Joins to load the Customer and Employee data fields into the Sales table.