From the table [Order Details] - List all details of all the above-average priced products (simple subquery) (718 records).
From the tables [Order Details] and Orders - List any products that have not appeared on an order in 1996 (subquery with [NOT] IN) (405 records).
From the tables Products and [Order Details] - List all details of products that have been sold (any date). We need this to run fast, and we don't really want to see anything from the [order details] table, so use EXISTS (77 records).