Get startedGet started for free

Planning the SELECT statement

When setting up queries, it is important to use the correct aggregations for fields. A common mistake is to incorrectly set up a ratio. In this exercise, your goal is to create a report that shows the ratio of nobel_prize_winners and pop_in_millions.

Which of the following SELECT statements would sufficiently create this report?

This exercise is part of the course

Reporting in SQL

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise