Somebody reported the fire fourteen minutes before it started. Prove it in real SQL. Learn the language from your first line, question a live evidence database, and let the records name the culprit for you.

Sign in to add this item to your wishlist, follow it, or mark it as ignored

Free Demo

Play Ghost in the SQL Data Demo

Check out the full game

 

About This Demo

Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.

Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.

Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.

Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!

System Requirements

Windows
macOS
    Minimum:
    • OS: Windows 10 (64-bit)
    • Processor: Dual Core 2,0 GHz (Intel Core i3)
    • Memory: 4 GB RAM
    • Graphics: Intel HD Graphics 4000 (support WebGL / DirectX 11)
    • Storage: 1 GB available space
    Recommended:
    • OS: Windows 10/11 (64-bit)
    • Processor: Quad Core 2,5 GHz or more
    • Memory: 8 GB RAM
    • Graphics: GPU (Intel Iris Xe / AMD Vega 8)
    • Storage: 1 GB available space
    Minimum:
    • OS: macOS 11
    • Processor: Apple M1 or Intel Core i5
    • Memory: 4 GB RAM
    • Storage: 1 GB available space
    Recommended:
    • OS: macOS 11+
    • Processor: Apple M1 or Intel Core i5
    • Memory: 8 GB RAM
    • Storage: 1 GB available space