Avg interview scores by location
Suppose your team is looking to see how interview scores may differ by location (while normalizing for differing roles) at your company.
You're given the below tables, detailing candidate roles/locations as well as associated interview scores. Using these tables, write a SQL query to return the average interview scores by role/location, and then provide the team with next steps outlining how you might test to see if the interview scores do indeed differ by location (you can assume the actual tables will have enough n-count for common statistical tests).
|lisa_perelli||Data Scientist||New York|
|jenny_west||Data Scientist||San Francisco|
Each row represents a unique interview/candidate as well as the candidate's score (an integer from 1-5, with 5 representing the highest possible score).
You can view/query the data in an interactive fiddle here.
Subscribe to premium account to see the solution.Get premium now