🛡️ Mission: Six Weeks to Save Reality A SQL Challenge Portfolio | Digits n Data 🌟 Project Overview This repository contains my solutions for the #SixWeeksToSaveReality SQL challenge hosted by Digits n Data. The challenge involved 6 high-stakes missions where data analysis was used to stabilize timeline anomalies and solve complex security breaches.
🛠️ Technical Skills Mastered Advanced Data Filtering: Using complex WHERE clauses and subqueries.
Relational Mapping: Executing multi-table JOINS to link personnel, security, and financial logs.
Sequence Analysis: Utilizing the LEAD() Window Function to track attack patterns.
Data Aggregation: Applying SUM(), MIN(), and GROUP BY for geographic and financial insights.
🕵️ Mission Glimpse
- Weeks 1-2: Identified 8 elite defenders and pinpointed Africa as the most unstable region using subqueries.
- Weeks 3-4: Unmasked a security traitor (steve.coulson@shield.com) and traced a 1,600,000 financial transfer via complex JOINS.
- Weeks 5-6: Pinpointed attack timestamps and resolved the final paradox with a Score of 30.
🤝 Experience & Acknowledgments This challenge pushed me to move beyond basic queries into a mission-first mindset—turning fragmented logs into actionable intelligence. The consistent progress shared by the Digits n Data community kept me motivated to stay on track and finish each task on time.
Special thanks to:
Mentors: @Muskan Kashyap & @Nitish Kumar for the guidance and engagement.
The Cohort: All fellow participants whose consistent work inspired my own journey.