SQL MYSTERY MISCHIEF

Case Overview:

Hello Detective,

AgriX is a highly intelligent, AI-accelerated microchip engineered with advanced parallel processing architecture, capable of executing up to 1,000 concurrent operations in real time with near-zero latency. It was reported stolen on 6th June 2025 from River Tech’s highly secure vault located on the 15th Floor. The floor is restricted to very few employees.

You are the detective hired by River Tech to find out who did this heist. Unfortunately, you’ve lost the case file but you vaguely remember there were 2 witnesses:

• A Customer Success team member who lives somewhere in Koramangala, has red hair, and a height between 155 cm and 160 cm.
• A security guard who has an ID that includes "011", is 173 cm tall, and lives in JP Nagar.

Firstly, find these 2 witnesses and get their interviews to start your case.

You've to answer the following questions:

1. What are the names of the 2 witnesses?
2. Who is the thief?
3. Who is the mastermind behind this heist?
4. What is the intent behind the heist?

Note: The answers to all the questions are in the Database. Find the Entity Relationship schema diagram below to understand how the database is designed. Start querying to get to the solution.

SELECT * FROM employee LIMIT 10;
Run SQL