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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
