write and execute the SQL queries that will produce the data (record sets) requested below using the pgAdmin 4 client and the Northwind Traders database (northwind_hw).

1. Which countries are our customers from? Sort the countries in descending order and be sure to list each country only once.

2. Which city is the customer, Centro comercial Moctezuma, located? Display the name of the city. 3. What were the orders placed by customers with the following IDs: SUPRD, LONEP, MEREP, PERIC, and RATTC? List the customer ID and order ID.

4. How many orders were placed between January 1, 1997 and December 31, 1997? NOTE: Your query must produce a result set with the number.

5. List the names of the products that are being sold, the quantities in stock, and units on order. HINT: Be sure to only include those products that have not been discontinued (i.e. discontinued is zero).

8) 8L Suppliers * Suppliers SupplierName ContactName ContactTitle Address City Region PostalCode Country Phone Fax HomePage Products 7 ProductID ProductName Suppliers CategoryID Unit Price UnitsinStock Units OnOrder ReorderLevel Discontinued Customers * Customers CustomerName ContactName ContactTitle Address City Region Postal Code Country Phone Fax Order Details * OrderID 9 ProductID UnitPrice Quantity Discount oo 00 00 Orders * OrderID Customer Employeeld OrderDate RequiredDate ShippedDate ShipperID Freight ShipName ShipAddress Ship City ShipRegion ShipPostalCode Ship Country Categories 7 CategoryID CategoryName Description Picture -1 Shippers * ShipperID ShipperName Phone Employees 7 Employeeld LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region Postal Code Country Home Phone Extension Photo Notes ReportsTo NOTE: The table names and field/column names in the PostgreSQL version of the Northwind Traders database are all in lower case. 8) 8L Suppliers * Suppliers SupplierName ContactName ContactTitle Address City Region PostalCode Country Phone Fax HomePage Products 7 ProductID ProductName Suppliers CategoryID Unit Price UnitsinStock Units OnOrder ReorderLevel Discontinued Customers * Customers CustomerName ContactName ContactTitle Address City Region Postal Code Country Phone Fax Order Details * OrderID 9 ProductID UnitPrice Quantity Discount oo 00 00 Orders * OrderID Customer Employeeld OrderDate RequiredDate ShippedDate ShipperID Freight ShipName ShipAddress Ship City ShipRegion ShipPostalCode Ship Country Categories 7 CategoryID CategoryName Description Picture -1 Shippers * ShipperID ShipperName Phone Employees 7 Employeeld LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region Postal Code Country Home Phone Extension Photo Notes ReportsTo NOTE: The table names and field/column names in the PostgreSQL version of the Northwind Traders database are all in lower case