Opportunities Won By Account

SugarCRM

 

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

Opportunities Won By Account

Query Text

SELECT Op."account_name" 'Account Name', op."name" 'Opportunity Name', date(Op."date_closed") 'Expected Date Closed'
  FROM "Opportunities" Op 
  WHERE Op."sales_status"='Closed Won' AND
        Op."account_name" is not null AND
        Op."date_closed" is not null  
  ORDER BY account_name

  

Open Query