SHADOWS OF THE BLACK STAR

URGENT: Metropolitan Police Database Division - TOP SECRET CLEARANCE REQUIRED

"This isn't just another case. This is war." — Inspector Megure

A shadow has fallen over Beika City. What began as isolated incidents has escalated into a coordinated campaign of chaos. The Mouri Detective Agency's expense records vanish. Cafe Poirot's sugar jars are rearranged like chess pieces. Teitan Elementary's lockers bear mysterious scratches. Beika Station's umbrellas walk away in pairs. Each scene tells the same story: a deliberate, mocking signature that reads BLACK_STAR.

This is no ordinary criminal. This is someone who knows the city's pulse, anticipates its moves, and leaves breadcrumbs that only the sharpest minds can follow. Someone who wants to prove they're smarter than everyone—the police, the detectives, even the legendary sleeping sleuth Kogoro Mouri himself.

You are the Database Analyst embedded with Conan Edogawa's investigation team. While Conan darts through shadows and Ran keeps the peace, your role is the silent weapon: mastering the art of SQL to weave disparate threads into truth. Every query you craft peels back another layer of deception. Every JOIN reveals connections others miss. Every WHERE clause filters out the noise to expose the signal.

The BLACK_STAR operative is counting on confusion, on isolated incidents that seem unrelated. But you see the pattern. Codes like "B7" appear in unexpected places. Times like "03:10" recur with ominous regularity. Suspects emerge from the digital shadows. Witnesses hold pieces of the puzzle. Your database is the weapon that will expose this phantom before they strike again.

The fate of Beika City rests on your SQL queries. Are you ready to join the hunt?

THE BLACK_STAR INVESTIGATION

  • Phase 1: The First Breadcrumb - Decode a mysterious code that haunts case files
  • Phase 2: Pattern Recognition - Unmask the BLACK_STAR signature across Beika City
  • Phase 3: Evidence Deep Dive - Unlock evidence tables and trace the operative's timeline
  • Phase 4: Suspect Analysis - Access suspect databases and identify the prime target
  • Phase 5: Witness Network - JOIN with witness statements for the complete picture
  • Phase 6: The Grand Reveal - Master multi-table JOINs to expose the BLACK_STAR operative

Progressive Unlocking: Tables remain locked until you've earned access through successful investigations. Each case builds your database permissions and reveals more of the conspiracy.

YOUR INVESTIGATION TOOLKIT

  1. Study the Case Brief - Each case reveals a new piece of the BLACK_STAR conspiracy with specific SQL objectives
  2. Access Unlocked Tables - Start with basic case files; earn access to evidence, suspects, and witness databases through successful queries
  3. Construct Your Query - Drag columns from available database folders into the visual query builder
  4. Apply Filters - Use WHERE conditions with AND/OR logic to isolate relevant evidence
  5. Execute & Correlate - Run queries to extract patterns and connections the naked eye can't see
  6. Document Findings - Successful queries populate your evidence board for the investigation team
  7. Escalate Clearance - Each solved case grants higher database access and reveals deeper layers of the conspiracy
  8. Master JOIN Operations - Advanced cases require combining multiple tables to expose the full truth