(Solved) : Given Following Tables Structure 1 Athletes Id Integer Sex Text Dob Text Height Float Weig Q26505569 . . . .

Given the following tables with the structure:

1. athletes(id integer,sex text,dob text, height float, weightinteger, nationality text ) (File in: https://ufile.io/escnl)

2. countries(country text,code text, population integer, gdpfloat) (File in: https://ufile.io/hjot8)

3. games(id integer,name text, nationality text, sport text,goldinteger, silver integer, bronze integer) (File in:https://ufile.io/oi758)

Use SQLite3:

1. Notice that some of the cells in the population column ofcountries are empty strings. Use the followingcommand to explicitly set these empty cells to NULL by updating thetable as follows:

UPDATE countries SET population = NULL where population=”;

With the empty cells filled with null values, you can use the ISNOT NULL keyword to exclude such rows in any