For each order, list the order number, order date, part number, number of units ordered, and quoted price for each order line that makes up the order.

Use the IN operator to find the number and name of each customer that placed an order on October $23$ of the current year. $***$Make sure to update the year of the dates in the tables to the current year first.

Find the number and name of each customer that did not place an order on October $23$ of the current year. $***$Make sure to update the year of the dates in the tables to the current year first.

For each order, list the order number, order date, part number, part description, and item class for each part that makes up the order.

Use a subquery to find the rep number, last name, and first name of each sales rep that represents at least one customer with a credit limit of $$10,000.$ List each sales rep only once in the results.

Find the number and name of each customer that currently has an order on file for a Gas Range.