Learn SELECT and FROM: THE ARCHIVE
Langley has detected anomalous database access from inside its own ranks. Your first assignment as a junior analyst: query the personnel archive and help counterintelligence narrow the suspect list.
Mission briefing
THE ARCHIVE is chapter 1 of the story campaign and the start of the mole hunt. Every mission here runs against the AGENTS table, a personnel roster with columns like CODENAME, REAL_NAME, STATUS, CLEARANCE_LEVEL, and STATION.
The drills cover the two keywords every SQL query is built on: SELECT and FROM. You pull the full personnel dump with SELECT *, then trim the output to specific columns so the shortlist never exposes real identities.
There are no multiple-choice questions. You type real queries into a terminal, a live database returns real rows, and the server verifies your result before the story advances.
A query pattern from this chapter
This is the shape of query you practice here, not the answer to any mission. The real stages come with their own data, objectives, and hints.
SELECT CODENAME, STATION
FROM AGENTS;Play Archive now
Free in your browser, desktop only. Guest mode starts instantly with no signup; sign in with Google if you want progress saved across devices.