and have asked you to write a query that clearly identifies the different types of address for each customer. Tip: Review the documentation for the UNION operator in the Transact-SQL Reference. 1.

We created two new tables departments and employees for the demonstration using Sample-tables.sql script. The SQL script is underfollowed. -- Create DEPARTMENTS table CREATE TABLE DEPARTMENTS ( ...