Science Olympiad Data Queries
1️⃣ Students Who Appeared in All Three Subjects
This query lists students who took Physics, Chemistry, and Biology.
2️⃣ Find the Student with the Highest Overall Marks
This query calculates total marks for each student across all subjects and displays the topper.
3️⃣ Show Centers Where More Than 100 Students Appeared
This query lists all exam centers that had more than 100 students appear in the Olympiad.
4️⃣ Retrieve Subjects with the Highest Average Scores
This query calculates the average marks for each subject and displays them in descending order.
5️⃣ Calculate the Rank Distribution in Physics
This query shows how many students achieved each rank in the Physics exam.
6️⃣ Students Qualified for Both Regional and National Levels
This query lists all students who qualified for both the Regional and National Olympiad levels.
7️⃣ Centers Where No Student Qualified
This query finds all centers where no student passed the qualification round in any subject.
8️⃣ Students Who Received Both Medals and Scholarships
This query lists students who received at least one medal and at least one scholarship.
9️⃣ Retrieve the Top 3 Students per Subject
For each subject, students are sorted by marks (highest first) and the top 3 are shown.
10️⃣ Students Who Scored Higher Than Average in All Subjects
This query lists students whose marks in each subject are higher than that subject’s overall average.
11️⃣ Show the Subject with the Most Participants
This query counts how many students appeared in each subject and shows the one with the highest participation.
12️⃣ Students Who Failed in at Least One Subject
This query identifies students who did not qualify in one or more subjects.