SQL Murder Mystery - Part 1

SQLDATA ANALYTICS

Can you solve this murder mystery using SQL? 🔪

The crime was a murder that occurred sometime on Jan.15, 2018, and that it took place in SQL City 🧐

Play this interactive SQLite game on 👉https://lnkd.in/gkaUZrP

I have attached the database scheme here 📚

Step 1

Query the database with the information that we do know. There was a murder that took place on Jan.15, 2018 in SQL City

now we know that there are 2 witnesses: One of them lives on Northwestern Dr, but we don’t know their name. The second witness’s name is Annabel and lives on Franklin Ave

Step 2

Query the person table for the number of people on Northwestern Dr, and find Annabel who lives on Franklin Ave. Now we can narrow our search with the interviews. Lets look in the interview table to find out what her transcript says

Step 3

Lets look at who checked in at gym on January 9th, 2018, membership status, and driving license table for the license id.

Find solution steps for Murderer in the below screenshot 👇

15+ years of IT work experience as Technical delivery Lead, Analytics Architect, AEP/CJA Implementation Consultant.

Adobe certified expert in Adobe Analytics, Adobe Target, Adobe Experience Platform (AEP), Real-Time Customer Data Platform (RT-CDP), Customer Journey Analytics (CJA), Journey Optimizer (AJO). Well versed with Google Analytics Server-side, Conversion API (CAPI), Privacy & Consent Management (OneTrust).

Deputed to Canada, USA, Netherlands, Germany, UK to work closely with business clients, business analysts, solution architects, solution designers, and other key stakeholders. Passionate to decode the online consumer behaviour by using an analytics data-driven approach.