Section 1: (30 points)

Using the test data in the following links, do the following exercises. Use the links to test your answers. 

1. a. Using the world table from http://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial (Links to an external site.)

 

List the countries in the Caribbean 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.)

 

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)

SophiaPretty

(5)

Status NEW Posted 20 Nov 2017 12:11 PM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer