I have a table named 'Sample' with the following columns:

order_category, customer_number, product_number,product_type, sales_value,month, year

Write SQL query to perform the following:

1. Write three separate SQL queries that use any three set operators.

2. Write an SQL query that uses the GROUP BY statement and one aggregate function.

3. Modify your previous query by adding the WHERE and HAVING statements.

4. Write an SQL query that includes the ROLLUP statement.

5. Write an SQL query that includes the CUBE statement.

6. Write an SQL query that includes the GROUPING SETS statement.

7. Write an SQL query that includes window functions.

8. Write three SQL queries that include several different analytical SQL functions