Kusto Detective Agency Season 2 — Case #6 Badge

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

Aviv Yaniv
Courisity is a Drug

--

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

KUANDA tentacles touch is back! 🐙

The sixth case riddle is:

The key takeaways from the riddle:

  1. We’re asked to decipher some text that contains instructions for new recruits for the KUANDA evil-power
  2. The cipher has to do with art gallery
  3. The cipher text is:

⚠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 NationalGalleryArt table has; ObjectId, Title, BeginYear, EndYear, Medium, Inscription, Attribution, AssistiveText, ProvenanceText, Creditline, Classification, ImageUrl.

We have details of art pieces, which sparks the desire to jump to see the Louver

…yet still doesn't help to solve the riddle🕵️

The number/number notation is Book Cipher, how could the two be related?

The first number is probably the ObjectId and the second number is the word location in ProvenanceText column based on numbers magnitude.

Let’s decipher!

We get the following song:

The key takeaways from the recruit instructions:

  1. There are three secret words in the Title field
  2. The words are case insensitive
  3. Word is finished as soon as there is any punctuation

all punctuations Mark the End

4. The words contain at least 3 characters

5. The instructions to find words are:

5.0. Three words create “line” of “time”

when found all, they form A line:
A clear timeline, simply Fine

5.1. Sort words by occurrences number descending

seeking the popular will guide you still

5.2. First word appears right after ‘King’

below The King, the first word mounts

5.3. Second word has the same counts as the word “Third”

the Second shares with Third their counts

5.4. The third word can be created from the 12th “marked dozen” word from the sorted list and the first two letters of the most common “most sought” word by changing a single character “change just one”

reveal the last word with Wise thought:
take first two letters from word most sought
into marked dozen, and change just one,
and with those two — the word is done

It’s time to fish the words from the ocean of data, let’s start by sorting words by their commonality:

The next word after KING by commonality is DAY, we got the first one!

The second word is YEAR sharing count with word THIRD.

The third word is the combination of the first two letters (TH) of the most common word (THE) and the twelve word (MAN), this creates MONTH.

The words do form a time line!

Armed with these words it’s time to extract Titles:

The following art is suspicious for having a lot of letters:

It’s time to take the ultimate step for a new recruit and log-in to KUANDA.ORG, we don’t know the password altogether this photo is a great hint:

OK! Password is by tentacle-order STOPKUSTO!

Viola! We’re in!

We have a lot of incriminating evidence and the leader's name — Krypto!

Gaia you’re free!

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”