File: hw1.txt Name: Collaborators: Due date: August 23, 2012, 11:59pm To handin: Create a folder in your CS account called cs457. Inside of that directory create a directory called handin. Leave your completed hw2.txt in your handin directory. Make sure not to change it after the due date - I will check the "last modified" time on the file. File permissions: make sure that your handin directory is not publicly readable. Use "chmod og-rx handin" and "chomd og-rx handin/*" to make the directory and files so they are not readable by others. I can still read your files because I have admin/root access. Task: Give correct SQL commands for each of the problems below. You can test them at http://sqlzoo.net/wiki/SELECT_basics Advice: Check the results for sanity. Just because you get an answer from the query does not mean you have the correct query. Grading: 1 point per problem To grade your problems, I will enter them myself at the link given about to see if they give the correct results. For each problem, if the query does not run at all, you get 0 points. If it is correct, you get full points. If it executes but is not correct, you may or may not get partial credit. * Problem 1 * Result should be a table with the name, population, and area of all countries with population at least 100 million and area at least 1 million. * Problem 2 * Result should be a single row with the total area and population of all countries in the table. * Problem 3 * Result should be a table with name area, population and gdp for all countries in North America. Assume that all countries with region = 'North America' or 'Americas' are in North America. * Problem 4 * Result should be a table with the name and population of the country (or countries if there are ties) with the largest population. * Problem 5 * Result should be a table with the name and population density (population/area) of the country (or countries if there are ties) that has the highest population density.