Instructions: Write SQL queries that will provide the answers to the following questions.

Use the Northwind Traders database to answer the following questions:

Which suppliers do we have on file that we can purchase Produce from? Show the supplier's company name in alphabetical order and do not list any supplier more than once. (Hint: Use the Categories, Suppliers, and Products tables. Produce is a category).

Which suppliers do we have on file that we can purchase both Seafood and Produce from? Show the supplier's company name in alphabetical order and do not list any supplier more than once. (Hint: Produce and Seafood are categories).

For each employee that has made at least 100 sales (placed 100 orders), list the employee's name and the total number of sales they have made. Provide a good column name for the total sales count and show the list in alphabetical order by employee's last name. (Hint: Use the Employee and Orders tables)

For each customer located in Spain, list the customer's CompanyName and the number of orders they have placed. Provide a good column name for the total number of orders placed count and show the list in alphabetical order by the customer's CompanyName.

Bonus Question (4 Points)

For all employees who were born in the 1970s, list the employee's name, and the number of employees that they supervise. Sort your list by last name and provide an appropriate column name for the number of supervisees.