Opportunities By Lead Source



SugarCRM is a cloud CRM from the SugarCRM software company, that includes sales force automation, marketing campaigns, customer support, collaboration, reporting, etc. features.

Opportunities By Lead Source

Query Text

SELECT t.lead_source AS Lead_Source, COUNT(*) AS Total_Count
  FROM Opportunities AS t
WHERE (t.assigned_user_id IS NOT NULL)
GROUP BY t.lead_source
ORDER BY Lead_Source

Open Query