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.

7. List the OrderID, ShippedDate and CompanyName of any order that was shipped on the same day as any of the orders that were shipped to "Norway". Use the ANY keyword. Use a subquery in the WHERE clause. (Hint: The main query requires two tables.)

8. List the SupplierID, ProductID, ProductName, and UnitPrice for each product whose UnitPrice is higher than the average UnitPrice for that Supplier. Use a correlated subquery in the WHERE clause. Order the list by SupplierId.