SQL
These two operators are used to combine multiple conditions in a SQL query.
What are AND and OR?
The Sister of Providence who arrived in Vancouver, Washington Territory in 1856.
Who is Mother Joseph?
The team dealing with ETLs, IDM, and DW issues.
What is the BI Team?
This application is typically used for running queries on SQL server.
What is SSMS (SQL Server Management Studio)?
A clause allowing columns or tables to be aliased (renamed) in the results set.
What is AS?
The year the first hospital in the Northwest, St. Joseph Hospital, opened.
When was 1858?
The team supporting group-facing reports.
What is Employer Group Reporting (EGR)?
This application is often referred to as the "bread and butter" app of data reporting.
What is Excel?
A clause used to narrow a result set to a specified number of rows.
What is LIMIT?
The Year Providence St. Vincent Medical Center opened.
When was 1875?
The team that quantifies savings for cost containment initiatives.
Who is Medical Economics?
An application whose "Show Me" menu boasts a variety of one-click viz-creation options.
What is Tableau?
A popular command that lets you filter query results based on specified conditions.
What is WHERE?
The title of the 1956 biography of Mother Joseph of the Sacred Heart.
What is "The Bell and the River"?
The team reporting on everything drug-related.
What is Pharmacy Analytics?
A programming language popular for web development, system scripting, data analysis, and automation.
What is Python?
A clause used to sort results by a specific parameter.
What is ORDER BY?
Annually on April 16th.
What is Mother Jospeh's birthday?
The team associated with HEDIS reporting.
What is HEDIS & Quality Analytics?
A programming language included in Microsoft Office.
What is VBA (Visual Basic for Applications)?
A constraint assigning a value for the column when no value is specified.
What is DEFAULT?
The cleric to whom this quote is attributed: "Humility, simplicity, charity, above all charity."
Who is Mother Gamelin?
The number of caregivers in Informatics (rounded to the nearest 5).
What is 65?
An Office 365 application used to automate workflows.
What is Power Automate?