LoslegenKostenlos loslegen

Report 3: Countries with high medal rates

Great work so far! It is time to use the concepts you learned in this chapter to build the next base report for your dashboard.

Details for report 3: medals vs population rate.

  • Column 1 should be country_code, which is an altered version of the country field.
  • Column 2 should be pop_in_millions, representing the population of the country (in millions).
  • Column 3 should be medals, representing the total number of medals.
  • Column 4 should be medals_per_million, which equals medals / pop_in_millions

Diese Übung ist Teil des Kurses

Reporting in SQL

Kurs anzeigen

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

SELECT 
	____,
    -- Add the three medal fields using one sum function
	____ AS medals
FROM ____ AS s
JOIN ____ AS c
ON ____
GROUP BY ____
ORDER BY medals DESC;
Code bearbeiten und ausführen