How would I go about determining two interesting views? Code is in SQL, all information I currently have is provided. The answer doesn't have to be 100% correct, just providing code to the best you can determine using the schema provided and question.

5. For your database, propose at least two interesting views that can be built from your relations. These views must involve joining at least two tables together each and must include some kind of aggregation in the view. Each view must also be able to be described by a one or two sentence description in plain English. Provide the code for constructing your views along with the English language description of what the view is supposed to be providing.