Add a view to the database:

The view should show the products and the customers that purchased them, ordered by product name. So the output of the view should include product name, customer name, order date, order quantity, ordered by product name and within product name ordered by order date.

(Note: theoretically and technically a view does not contain a sort order, but for our purposes include it).

NOTE: -- using Microsoft SQL server management Studio