The Board of Directors of Northwind Traders have appointed Doug Hanus at their new CEO and Jeff Hogan as their operational manager. They are planning to devote their first two weeks in office to gain a better understanding of Northwind's supply chain and marketing processes. As senior database analyst for Northwind, it is your responsibility to code appropriately structured SQL statements for retrieving the following information requested by Doug and Jeff. They need it on or before 10/01/2023. 6. The product names and corresponding category names for products in orders with OrderID 10257 and 10267 . The report must be sorted by category name. [15 pts] 7. 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. [15 pts] 8. The number of products supplied by each supplier for products priced less than 30. Each supplier must supply at least two products. Your report should show the number of products and SupplierID. [15 pts.]