Can Views do math and complex queries?

Some samples of what I need:

Note: Wholesale customers have a special role assigned to them.

Note: All reports are based on sales over a date range that should be selected by the user.

For each product, the total count purchases for the given time period (Yes, Ubercart does this one already.)

Twenty percent of total sales (in dollars) to wholesale customers. I.e., add up the total sales to wholesale customers and multiply by 20%.

Total sales tax paid by customers.

Thirty-seven percent of total sales to non-wholesale customers of products with product (node) type "Book".

More notes:

{uc_orders} contains order records, including the (customer) user ID, the order ID, date purchased, and the status of the orders. Only orders where the status indicates that the purchase is complete should be counted.

{uc_order_products} contains the products that are in orders. Each record contains the order ID, the node (product) ID, the quantity ordered, and the actual price paid.

{uc_order_line_items} contains tax and shipping line items in orders. Each record contains the order ID, the title of the item, the type of the item (tax/shipping) and the amount paid.

{role} contains the role name and role ID for each role.

{users_roles} contains the user ID and role ID of each role assigned to each user.

{node} contains the node ID and node (product) type of each product.

{node_type} contains the node ID and node name of the different node (product) types.

I could do all this by writing a module that would build SQL queries and put the results into some tables, but maybe Views is a better way to do it. Either way, it's going to involve a series of queries with PHP to apply logic, or some really gnarly selects somehow joining six of those tables at a time.

So, is Views the way to go?