Kusto Detective Agency Season 2 — Case #3 Badge

Walk Through Guide for Kusto Detective Agency Season 2, Case #3 Solution

Aviv Yaniv
Courisity is a Drug

--

Cases Solutions: 0 1 2 3 4 5 6 7 8 9 10

GTA has arrived at DigiTown! 🚗

The third case riddle is:

The key takeaways from the riddle:

  1. A total of 20 cars were stolen and their original plate are known
  2. Robbers have changed cars plate numbers in hidden spots
  3. Robbers have a single rendezvous spot for cars, we’re asked to find it

⚠SPOILER ALERT — THE SOLUTION DESCRIBED BELOW⚠

Note: Solution is mine, and non-official

So let’s delve into the data, by leveraging the | take 10, to see some rows.

The CarsTraffictable has; Timestamp, VIN, Ave, Street.

We also have access to the stolen cars old plates numbers:

Robbers have changed the plates' numbers, so to find the final rendezvous point we have to track logically their journey…

Let’s start by finding the hidden places in which they replaced plates.

Let’s find for the stolen cars the last places most of them were seen:

We don’t know the new plates numbers for the stolen cars, altogher we do know that they visited the plates changing point and that they all collected to a single rendezvous spot.

We expect this rendezvous spot to have total amount of stolen cars with a reasonable amount of few more cars of robbers:

Robbers caught! 👮⛓ plus one extra car (hope its Ferrari!)

Enjoyed this article? Feel free to long-press the 👏 button below 😀

Click for Next Case Solution ➡

Click for Previous Case Solution ⬅

Cases Solutions: 0 1 2 3 4 5 6 7 8 9 10

--

--

Aviv Yaniv
Courisity is a Drug

Senior Software Development Engineer 🖥️ Economist 📈 Beer Brewer 🍻 Photographer 📷 ~ “Curiosity is my drug”