Sales By Accounts



Salesforce is the most popular cloud CRM with a focus on sales and support.

Which accounts are responsible for sales

Query Text

SELECT Owner.Name AS "Opportunity Owner", Account.Name, Opportunity.Name AS "Opportunity Name", Opportunity.Fiscal AS "Fiscal Period", Opportunity.CloseDate, Opportunity."Type", Opportunity.Amount
  FROM Opportunity
LEFT OUTER JOIN Account ON Opportunity.AccountId = Account.Id
INNER JOIN User AS Owner ON Opportunity.OwnerId = Owner.Id
WHERE (Opportunity.IsClosed = True AND Opportunity.IsWon = True)
ORDER BY Account.Name

Open Query