SQLSQL byteStarter~2h time-box

Orbital People Ops

It is your second week aboard {{COMPANY}}'s orbital station, and your first major assignment is a reporting project for the people ops team. You need to query crew records from the 1980s and 1990s.

Use this byteMore SQL bytes
Orbital People Ops
Step 1
Clone the starter repo
Candidate gets the full project locally — README, source, tests, runner config.
Step 2
Run the visible tests
Public test file is right there. Expectations are explicit from minute one.
Step 3
Make tests pass, push
Candidate works in their own style, pushes reviewable commits for your team.
Starter repo
What candidates clone
3 files
  • crew_departments.sql
  • crew_details.sql
  • crew_hires_1986.sql

The full README and the hidden test suite are available once you open the byte in your CodeSubmit workspace. Candidates never see the hidden tests.

Skills tested
selectjoinscounts
Difficulty
Starter

Fundamentals-level. Clear requirements, straightforward execution.