Another interesting question one of my students has sent me recently. Given the following Orders table. As you can see, this table has four columns : customer number, supplier number, order number, and order date.

image

Create a query to display the highest order date for each customer. For example, using the values shown above, the query will retrieve the following result:

image