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