Skip to content

Query: Qry Report Opal Calculate Tenure by Gender

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

Tables Referenced

  • Qry Report Opal Sum Length of Service by Gender
  • Qry Report Opal Count Hired and Terminated Employees by Gender
  • Qry

Columns Selected

  • Gender
  • [Gender Total Tenure]/[Gender Number]

SQL

SELECT [Qry Report Opal Sum Length of Service by Gender].Gender, [Gender Total Tenure]/[Gender Number] FROM [Qry Report Opal Sum Length of Service by Gender], [Qry Report Opal Count Hired and Terminated Employees by Gender]