1. Create a report contains total values of the ordered items by country in each year. (Note: use the following tables: Order_item, Orders and Customer_dim ) Print the program and the report.
2. Construct a confidence interval (95%) for the average values of ordered items by gender (Note: use the following tables: Order_item, Orders and Customer_dim) Print the program and the report.