Diversity of queries is also important you can t get full credit for five variations on the same query. Try to relate the queries you write here to the functional requirements you listed earlier. Queries with clear practical use related to your spec will receive more credit. Try to cover as many of the following as possible. All these were covered in class the project is your chance to experiment with and apply them.
Extra credit is available here.
At least one query with some calculated fields Nice formatting of data and time Creation of a view, use of same view in other queries. Use of view for logical data abstraction. A summary query using group by and at least one aggregate function. Queries that demonstrate use of constraints, cascading deletes, etc. Subqueries, especially when the use of a join would be clumsy.