SugarCRM is a cloud CRM from the SugarCRM software company, that includes sales force automation, marketing campaigns, customer support, collaboration, reporting, etc. features.
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