1. What is the total revenue generated from all orders?
2. How many distinct customers have placed orders?
3. What is the average credit limit of all customers?
4. For each sales representative, calculate the total number of customers they are assigned to. Then, create a bar plot visualizing the number of customers per sales representative.
5. Calculate the average credit limit for customers in each region. Then, generate a bar plot comparing the average credit limits across the different regions.
6. Create a bar plot showing the number of customers in each city.
7. Generate a scatter plot showing the relationship between the quantity of an item ordered and the quoted price in the order_item table.
8. Calculate the total revenue generated by each product category. Then, create a bar plot showing the total revenue for each category.
9. For each sales representative, find the average credit limit of the customers they manage. Then, create a bar plot visualizing the average customer credit limit for each sales representative.
10. Create a box plot comparing the credit limits of customers across different regions.