Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

e. 12 pt] Handling Empty Cells: Notice that some of the cells in the population column of countries are empty strings. Use the following command

image text in transcribed
e. 12 pt] Handling Empty Cells: Notice that some of the cells in the population column of countries are empty strings. Use the following command to explicitly set these empty cells to NULL by updating the table as follows: UPDATE countries SET population = NULL where populations!! With the empty cells filled with null values, you can use the IS NOT NULL keyword to exclude such rows in any query Once you have updated the countries table to fill the empty cells with null values, list the top 5 most populated countries along with the sum of all medals (gold, silver and bronze combined) won by the country. Your result should be ordered by country population from highest to lowest For example: if 'United States' has won 10 medals in total and United Kingdom' has won 12. but USA is more populated than UK, then your result should order them as follows: United States, 10 United Kingdom, 12 Format of each line in the output (5 lines total) full_country_name, sum_of_medals

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

1 2 3 Data Base Techniques

Authors: Dick Andersen

1st Edition

0880223464, 978-0880223461

More Books

Students also viewed these Databases questions