Skip to content

Query: Qry Report Opal Calculate Percentage by Management Race

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

Tables Referenced

  • Qry Report Opal Count Hired Employees by Management Race
  • Qry Report Opal Count Total Hired Employees
  • Qry

Columns Selected

  • [Qry Report Opal Count Hired Employees by Management Race].[Is Management]
  • Race
  • [Qry Report Opal Count Hired Employees by Management Race].[Management Race Numb
  • [Management Race Number]/[Total Employees]

SQL

SELECT [Qry Report Opal Count Hired Employees by Management Race].[Is Management], [Qry Report Opal Count Hired Employees by Management Race].Race, [Qry Report Opal Count Hired Employees by Management Race].[Management Race Numb, [Management Race Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Management Race], [Qry Report Opal Count Total Hired Employees]