That's a lot of sql :), and the perfect scenario to use the summarize feature.