In Northwind database 2019: If the question states to use a subquery and a subquery is not used no credit will be given for the question.

4. List the OrderID, CustomerID, OrderDate, and Freight from the orders table for all orders where the freight cost is greater than the average freight cost. Use a subquery in the WHERE clause.

5. List the ProductID, ProductName, and the UnitPrice (name this column 'Price') for all products where the supplier's Country is either 'Germany' or 'Italy'. Display the 'Price' with two decimal places. Order the list by the ProductName. Write a standard multiple table query. (Hint: This query requires two tables.)