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.

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

6. List the ProductName and UnitPrice of all products that have a lower UnitPrice than any product supplied by 'Mayumi's". Use the ALL keyword. Use a subquery in the WHERE clause. (Hint: The subquery requires two tables.)