c. Please write a SQL query that the administrative assistant can use to create mailing labels for their HOME address and fill in some variables for a form letter. Assume your query result window will allow the results to be saved to a tab delimited file format that the admin can import and auto-create labels/letters. The format should be as follows: EmployeeID, LoginID, Mr or Mrs, HireDate, VacationHours, AddressLine1, AddressLine2, City+State+Zip. Please sort the results by City Name in ascending alphabetical order. NOTE: Legal has confirmed non- salaried employees are not subject to accrual limits and should therefore NOT be included in the result set.

Employee EmployeeAddress PK EmployeelD Address PK EmployeelD PK AddressID PK AddressID ContactID LoginID Title Gender HireDate BirthDate SalariedFLG VacationHours SickLeaveHours CurrentFLG ModifiedDate MaritalStatus AddressLine1 AddressLine2 City StateProvincelD PostalCode ModifiedDate AddressDate AddressType Employee EmployeeAddress PK EmployeelD Address PK EmployeelD PK AddressID PK AddressID ContactID LoginID Title Gender HireDate BirthDate SalariedFLG VacationHours SickLeaveHours CurrentFLG ModifiedDate MaritalStatus AddressLine1 AddressLine2 City StateProvincelD PostalCode ModifiedDate AddressDate AddressType