As senior database analyst for Northwind, it is your responsibility to code appropriately structured SQL statements for retrieving the following information:

$1.$ A listing of the customer name, last name of employee who accepted the order for all orders from customers based in the United States and Canada and shipped through United Package. The report must be sorted alphabetically by customer name.

$2.$ A listing of the customer name, last name of employee who accepted the order for all orders from customers based in the United States and Canada and shipped through United Package. The report must be sorted alphabetically by customer name