Ginni has created a table, SCORES in MySQL to store runs scored by players in…

2025

Ginni has created a table, SCORES in MySQL to store runs scored by players in a cricket match. The table contains the following records: PLAYER SCORE Ranveer 50 Sukesh 35 Jirsa 10 Mohan 15 Murugan 70 Which of the following statements will give 10 as output?

  1. A.

    SELECT MAX(Score) FROM Scores;

  2. B.

    SELECT MIN(Score) FROM Scores;

  3. C.

    SELECT SUM(Score) FROM Scores;

  4. D.

    SELECT AVG(Score) FROM Scores;

Attempted by 931 students.

Show answer & explanation

Correct answer: B

To determine which statement returns 10 as output, evaluate each option based on the given table: PLAYER SCORE Ranveer 50 Sukesh 35 Jirsa 10 Mohan 15 Murugan 70 Option A: SELECT MAX(Score) FROM Scores; MAX(Score) returns the highest score, which is 70. So, this option returns 70, not 10. Option B: SELECT MIN(Score) FROM Scores; MIN(Score) returns the lowest score, which is 10. So, this option returns 10. Option C: SELECT SUM(Score) FROM Scores; SUM(Score) adds all scores: 50 + 35 + 10 + 15 + 70 = 180. So, this option returns 180, not 10. Option D: SELECT AVG(Score) FROM Scores; AVG(Score) calculates the average: (50 + 35 + 10 + 15 + 70) / 5 = 180 / 5 = 36. So, this option returns 36, not 10. Therefore, only Option B returns 10 as output.

Explore the full course: Bpsc