Skip to content

Query: Qry Report Team Activity Super Summary

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

Tables Referenced

  • Qry
  • Qry Report Team Activity Detail

Columns Selected

  • [Qry Report Team Activity Detail].[Application Status]
  • [Qry Report Team Activity Detail].[Sort Order]
  • Count([Qry Report Team Activity Detail].[Application Status History ID])
  • Sum([Qry Report Team Activity Detail].[Time Unit])

Order By

[Qry Report Team Activity Detail].[Sort Order]

SQL

SELECT [Qry Report Team Activity Detail].[Application Status], [Qry Report Team Activity Detail].[Sort Order], Count([Qry Report Team Activity Detail].[Application Status History ID]), Sum([Qry Report Team Activity Detail].[Time Unit]) FROM [Qry Report Team Activity Detail]