CASE IDP-2026-117
Case file IDP-2026-117

The Case of the
Missing Budget

Island Drama Productions Sdn Bhd 路 producers of Fruit Love Island

Confidential
The cash is gone.
Somebody in this office is lying.
Who? How? How much?

Reference: always open

Case Briefstart hereSuspects7 fruits, 1 org chartChart of Accountsfor the accountantsQuery Cheat SheetSQL + accounting refresher

Investigation: each act opens its own database

Act 0 路 Practicewarm up in the SQL editor
Act 1 路 Follow the moneySealed
Act 2 路 Whose fingerprintsSealed
Act 3 路 The frameSealed

Persons of interest

Bananito, Head of ProcurementBananitoHead of ProcurementStrawberrina, Accounts Payable ClerkStrawberrinaAccounts Payable ClerkKiwilo, Database AdministratorKiwiloDatabase AdministratorGrapenzo, Chief Financial OfficerGrapenzoChief Financial OfficerCherrita, Procurement InternCherritaProcurement InternPineapena, Senior AccountantPineapenaSenior AccountantOrangelo, HR ManagerOrangeloHR Manager

Tonight's episodes

  1. Act 0Practice case
  2. Act 1Betrayal at Sunset
  3. Act 2The Secret Note
  4. Act 3Casa Amor
  5. FinaleThe Public Vote
  6. RevealThe Final Decision