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.

2. 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.) *This question doesnt need to be answered, but it applies to Question 3 because I need a subquery in the where clause*

3. Write the same query as above but do not use a join. Instead, use a subquery in the WHERE clause.

4. List the ProductID, ProductName, UnitsinStock and CategoryID of products in Category 2 whose number of units in stock is more than average of all products. Use a subquery in the WHERE clause.