Skip to content

Query: Qry Report Opal Calculate Percentage by Race Gender

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

Tables Referenced

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

Columns Selected

  • Race
  • Gender
  • [Qry Report Opal Count Hired Employees by Race Gender].[Race Gender Number]
  • [Race Gender Number]/[Total Employees]

SQL

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