Write a query using a JOIN and GROUP BY to find total revenue per product category.