SQL Capstone Mission: THE BREACH

BREACH is the final mission of the 15-chapter story campaign. Three classified tables are on the desk: OFFICERS, MISSIONS_LOG, and EVALUATIONS, linked by OFFICER_ID. Producing the debrief means joining across all three, counting missions per officer, and folding in performance ratings. Every query runs live in your browser.

The stages escalate from a three-table join to grouped mission counts to an elite-officer report that combines joins, aggregates, and HAVING in a single query. Nothing new is introduced; everything learned since THE ARCHIVE is tested.

Clear it and the campaign is complete. The Proving Ground's timed interview drills are the natural next stop.

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 OFFICERS.NAME, COUNT(*) AS MISSION_TOTAL
FROM OFFICERS
INNER JOIN MISSIONS_LOG ON OFFICERS.ID = MISSIONS_LOG.OFFICER_ID
GROUP BY OFFICERS.NAME;