💾 ByteCorp DB Recovery

System Status: CRITICAL // Database Architect Missing

User: Guest_DBA Connection: ESTABLISHED Database: SQL_Challenges

  +-------------+       +-------------+       +-------------+
  |  EMPLOYEES  |       | DEPARTMENTS |       | HIDDEN_VAULT|
  +-------------+       +-------------+       +-------------+
  | id (PK)     |----<  | id (PK)     |       | id (PK)     |
  | name        |       | name        |       | note        |
  | dept_id (FK)|       | floor       |       | code_frag   |
  +-------------+       +-------------+       +-------------+

Mission 01: The Roll Call

We need a list of everyone in the system. Find the name of the employee with ID 999.

HINT: SELECT * FROM employees WHERE...

Mission 02: The Big Earner

Someone is earning a salary of exactly 1,000,000. What is their Role?

HINT: WHERE salary = ...

Mission 03: Final Assembly

The final flag is split across the `hidden_vault` table. Combine all `code_fragments` in order (1, 2, 3).

HINT: SELECT code_fragment FROM hidden_vault...