QI$.$ Write a query to retrieve the top $10$ order amounts from customers, the product information for those orders, and calculate the sum of the order amounts.

Q$2.$ Write a SQL query to find the category in which a customer ordered the most and calculate the total of that category.

Q$3.$ Write an SQL query to get a list of orders placed by customers in Seattle and calculate the total amount of all orders.

Q$4.$ Write a SQL query that lists the names of the vendor companies that provided the products and sorts them in order of total revenue if the revenue generated by the products taken by employees with the job title "Sales Representative" is more than $$10,000.$ What is the total of all vendor sales?

Q$5.$ The owner of Northwind Traders wants to know if his staff is deployed effectively. For example, he might assume that there are more employees in areas where there are more orders for goods, or that there are more employees in areas with high sales. You need to analyze the staffing status so that he can make a decision. You analyze the data in SQL and use the quantitative evidence from your analysis to form an opinion about the staffing.

$$ Suppliers: Suppliers and vendors of Northwind

$$ Customers: Customers who buy products from Northwind

$$ Employees: Employee details of Northwind traders

$$ Products: Product information

$$ Shippers: The details of the shippers who ship the products from the traders to the end$-$customers

$$ Orders and Order$\_$Details: Sales Order transactions taking place between the customers & the company