FIELD TRAININGSQL
Choose your level
Select any level. You get three lives for each program attempt; three unsuccessful queries end that attempt. Hints are free, and you can practice completed missions without risking lives.
Midnight Protocol
0 / 40 XP
MISSIONS CLEARED
The Roster
CLEARED
YOUR OBJECTIVE
QUERY CONSOLEWrite your SQL on a new line below the comment.
Database schema Show tables & relationships
PK Primary keyFK Foreign key1 : N One to many
agents
- PK
agent_idINTEGER call_signTEXTdivisionTEXTstatusTEXTthreat_scoreINTEGER
mission_logs
- PK
log_idINTEGER - FK
agent_idINTEGER - FK
mission_idINTEGER statusTEXT
missions
- PK
mission_idINTEGER mission_nameTEXTregionTEXTrisk_levelTEXTstatusTEXT
One agent can have many logs. One mission can have many logs.
evidence
- PK
evidence_idINTEGER detailTEXT
Your queries run in this browser.
MISSION OUTPUT
AWAITING QUERYRun your query to see the results here.