---

select count(*) opps, sum( caseAmt ) as caseAmt, sum( caseImpact ) as caseImpact, sum( altAmt ) altAmt, sum( altImpact ) altImpact from qmd_pipeline select * from qmd_pipeline order by companyName, opportunityName