Write a SQL query against the Northwind database that lists the dollar amount each employee shipped to a particular country. Identify each employee by employee ID. The output of your result should contain the following header columns: Employee ID, Ship Country, and Amount. Building on the previous SQL query, write another query using a pivot that lists the total dollar amount shipped to each country by each employee. The output of your query result should contain the following header columns: Employee ID, Austria, Finland, Italy, France, Germany, Brazil, Belgium, and Switzerland.

Please explain how I could provide the schema. A new schema has not been applied to the database. It has just been downloaded.