Logo
Digits n Data
Six Weeks To Save Reality - Question 1

Question 1: The Etheral Sign

The Crisis: Timeline Instability Detected

Something is wrong with time itself. Energy readings across the planet are spiking at impossible levels.

Then… the unthinkable happens. Tony Stark’s A.I. comes back online... self-reconstructed, half-corrupted, but active.

“The timeline is breaking. I detect six distinct energy signatures... all matching the Infinity Stones.”

Immediate Assessment Required:

Before doing anything, we must assess Earth’s defense. The Avengers’ systems are outdated. Many records are corrupted. We need to identify our Strongest Defenders immediately.

Specifically, we need to know:

  • Who is still Active?
  • Who is assigned to Primary Defense?
  • Whose Mission Success Rate is higher than the Team Average?

Your Task:

Find how many active Avengers have a Mission Success Rate higher than the team average and are assigned to Primary Defense.

Dataset: AvengersData
AvengerIDNameStatusMissionSuccessRateAssignment

Important Notes

1. The output you generate (a single number in this case) will serve as your password for the next mission.

2. After completing the task, share the question, your query and an explanation of your approach on LinkedIn before starting next question. Make sure to tag us: Muskan, Nitish and Digits N Data. Creativity matters!

3. Do NOT share your password or the dataset anywhere.

4. If you believe your query is correct but the system marks it incorrect, don’t worry — there are multiple valid ways to approach SQL problems.

In that case:

  • Save your result somewhere and use it as the password. If your query is correct, your result will unlock the question., or
  • If you're stuck, reach out to Muskan on LinkedIn

5. Do not copy someone else's work. This will disqualify you immediately.

6. Remember, the win isn’t just about getting the query right... it’s about presenting your solution in the most creative and engaging way.