Average Employee Popularity By Location

Facebook

Interview Core Track · Easy · 15 min

Facebook wants a scorecard for average employee popularity by location. The workplace insights team wants to compare employee survey popularity by office loc...

Interview Core Track

Easy

15 min

joins

aggregation

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice joins through a Facebook-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

Facebook wants a scorecard for average employee popularity by location. The workplace insights team wants to compare employee survey popularity by office location. Return each location and the average popularity score for employees in that location.

facebook_employees

id INT PRIMARY KEY

name VARCHAR(100

facebook_hack_survey

employee_id INT

popularity INT

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.