Closed deals by owner

SQL query for Salesforce

Get closed deals by owner from Salesforce data.

SELECT Owner, COUNT(*) as Closed_Deals FROM Deals WHERE Status = ‘Closed’ GROUP BY Owner

Salesforce data model

Table Account

Table Campaign

Table Case

Table Contact

Table Contract

Table Invoice

Table Invoice Line

Table Identity Verification Event

Table Legal Entity

Table Lead

Table Lead Status

Table Login Event

Table Opportunity

Table Opportunity Line Item

Table Order

Table Order Item

Table Organization

Table Partner

Table Payment

Table Payment Method

Table Payment Line Invoice

Table Pricebook

Table Pricebook Entry

Table Refund

Table Task

Table User Login

Table Work Order Line Item

Magical SQL for Salesforce with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.