Please use the northwind database for this question. The objective of this question is to allow students to showcase the SQL queries they have learned.

Using SQL, create 10 different queries that will pull information from these tables in different formats. E.g., showing one customer and their details, the average cost of products, age of employees etc. Look through the notes to find examples on these different formats.

1. Include queries that cover: Like, %, _ , and some functions like avg, count, length etc
2. Include a query that uses GROUP BY and another one that has GROUP BY and HAVING.
3. Include at least 3 queries that use some sort of join e.g. INNER JOIN or LEFT JOIN. A GROUP BY query could also involve a Join.
4. Include one query that contains a sub query.
5. Include one database view.