MISSION BRIEFING // PART 1

To keep tabs on the whereabouts of our agents, we maintain a record of flight logs in the Flight Ledger Yard, or F.L.Y. for short. Each flight log in F.L.Y. contains the agent’s social security number, city, time of arrival, and time of departure to/from our major spy hubs. In addition to past flights, F.L.Y. also maintains data on upcoming flights so that we can manage the assignments of our agents, so you will need to be careful when processing the data.

Your task is simple: Determine what city Agent Web was located in at the time of his last ping to our headquarters.

Here is some information that may be helpful in your endeavors:

  • Agent Web's Social Security Number: 002-05-1849
  • Agent Web's Last Ping Time: 2025-10-08T20:37:00Z

Good luck!

→ Submit your answer to unlock Part 2

SQLITE_QUERY_TERMINAL // PART_1

ANSWER_SUBMISSION

QUERY_INPUT