Question

Calculate the running total of athlete medals. Athlete, medals, sum(medals) over (order by athlete asc) as max medals from athlete medals order by athlete asc;

a) The query is not valid in SQL.
b) The query calculates the running total of athlete medals.
c) The query retrieves athlete names in ascending order.
d) The query calculates the average medals for each athlete.

Answer 1

The query calculates the running total of athlete medals.

Step-by-step explanation:

The correct option for this question is b) The query calculates the running total of athlete medals.

The given SQL query uses the window function sum(medals) over (order by athlete asc) to calculate the running total of athlete medals. The order by athlete asc clause ensures that the running total is calculated in ascending order of athlete names.

For example, if we have the following athlete medals:

• Athlete Medals
• A1 3
• A2 2
• A1 2
• A3 5

The running total of athlete medals will be:

• Athlete Max Medals
• A1 5
• A1 5
• A2 2
• A3 5