Data Interview Qs - 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).

Table: candidateInfo

Table: candidateInterviews

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.