TOP10 Salespeople

Salesforce

 

Salesforce is the most popular cloud CRM with a focus on sales and support. Skyvia requires Salesforce Enterprise edition or higher.

TOP10 Salespeople

Query Text

SELECT u."Name", SUM(o."Amount") 'Amount SUM', SUM(o."ExpectedRevenue") 'ExpectedRevenue SUM'
  FROM "Opportunity" o, "User" u
  WHERE o."IsWon"=true AND
        o."IsClosed"=true AND
        o."OwnerId"=u."Id"
  GROUP BY o."OwnerId"
  ORDER BY 'Amount Sum' DESC
  LIMIT 10
  

Open Query