10070 Deepmind Employment Competition

Google

Interview Core Track · Easy · 15 min

SELECT p.team_id, AVG(s.member_score) as team_score FROM google_competition_participants p JOIN google_competition_scores s ON p.member_id = s.member_id GROU...

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 Google-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

SELECT p.team_id, AVG(s.member_score) as team_score FROM google_competition_participants p JOIN google_competition_scores s ON p.member_id = s.member_id GROUP BY p.team_id ORDER BY team_score desc

google_competition_participants

member_id INT PRIMARY KEY

team_id INT NOT NULL

member_name VARCHAR(100

google_competition_scores

member_id INT PRIMARY KEY

member_score NUMERIC(6

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.