Skip to content

Query: SubQry Rpt Average Time Through Pipeline by Delivery Location

Type: Select
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

  • SubQry
  • SubQry Rpt Average Time Through Pipeline Criteria

Columns Selected

  • Pipeline
  • [SubQry Rpt Average Time Through Pipeline Criteria].[Distribution Model]
  • [SubQry Rpt Average Time Through Pipeline Criteria].[Delivery Location]
  • Count([SubQry Rpt Average Time Through Pipeline Criteria].[Entrepreneur ID])
  • Sum([SubQry Rpt Average Time Through Pipeline Criteria].[Pipeline Days])

SQL

SELECT [SubQry Rpt Average Time Through Pipeline Criteria].Pipeline, [SubQry Rpt Average Time Through Pipeline Criteria].[Distribution Model], [SubQry Rpt Average Time Through Pipeline Criteria].[Delivery Location], Count([SubQry Rpt Average Time Through Pipeline Criteria].[Entrepreneur ID]), Sum([SubQry Rpt Average Time Through Pipeline Criteria].[Pipeline Days]) FROM [SubQry Rpt Average Time Through Pipeline Criteria]