Ghost in the SQL Data

Steam|SimulationStratégie

Un appel a signalé l’incendie d’un collège 14 minutes avant que le premier témoin le voie. Trouvez qui l’a passé, en SQL, en fouillant une année d’appels d’urgence à Paris.

Section du jeu

unfold_more

The First Filter92.1%

Run a query with WHERE that comes back with rows.

Roughly Right16.3%

Run a query with LIKE that comes back with rows.

A Short List23.7%

Run a query with IN that comes back with rows.

A Query Inside a Query13.0%

Run a query holding another query that comes back with rows.

One of Each20.7%

Run a query with DISTINCT that comes back with rows.

Two Tables79.4%

Run a query with JOIN that comes back with rows.

One Row Per Group22.8%

Run a query with GROUP BY that comes back with rows.

What It Adds Up To6.2%

Run a query with SUM that comes back with rows.

After the Count9.9%

Run a query with HAVING that comes back with rows.

In Order69.2%

Run a query with ORDER BY that comes back with rows.

The Scratch Table3.4%

Run a query with WITH that comes back with rows.

The Ashgrove Fire88.3%

Close the Ashgrove fire case.

The Lodge63.8%

Close the lodge case.

Ten Strangers14.3%

Close the ten strangers case.

Taught Once95.7%

Finish the tutorial.

Metropolitan Crime Unit63.8%

Close every case of the crime unit.

Straight Through45.3%

Close a case with no hint and no failed checkpoint.

Closed5.1%

Close every case.

Nobody Saw That59.5%

Reveal a hint.

Near "Everything"79.0%

Get your first syntax error.

Not Your Table2.8%

Try to change the data. The desk says no.

Nothing To Report78.4%

Run a query that comes back with no rows.

Note to Self21.5%

Leave a comment in a query.

A Hundred Questions29.2%

Run 100 queries.

The Switchboard73.6%

Close the switchboard case.

The Orsay Crown18.2%

Close the Orsay crown case.

The Hospital Stalker31.1%

Close the hospital stalker case.

The Blue Houses48.2%

Close the blue houses case.

Elixir V10.1%

Find the 3 flowers of Elixir V.

The Next Bank24.9%

Close the next bank case.

Letters From La Sante8.5%

Read the crew's 7 meetings with K.

Who Is K?5.4%

Name K, and who pays him.

Succès secret2.3%

Appuyez sur son image pour le révéler.

Off the Press0.5%

Publish your first case on the Workshop.

Read in Ten Homes0.3%

Have 10 players subscribe to one of your cases.

Someone Else's Case6.5%

Close a case from the community.

Five Strangers' Files0.8%

Close 5 different cases from the community.

The Readers' Column0.4%

Close 10 different cases from the community.

Chargement...