- a. Using the world table from http://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial (Links to an external site.)Links to an external site.
List the countries in South America and their per population density, rounded to the nearest whole integer, sorted by population density in descending order (i.e. the most densely populated, first)
(for info on the Round function, see the Functions page on the same sqlzoo.net site)
b. Go to page http://sqlzoo.net/wiki/More_JOIN_operations (Links to an external site.)Links to an external site.
List all movie titles and years in which Tommy Chong appeared (hint; sometimes the name column in the actor table contains multiple names, so you want to find any that contain this name)