CMIS 320
Name:____________________
Create the Geom database using the geom.sql file.
geom.gif is the world
0. How many points are there:
1. What is the largest X, largest Y, smallest X, smallest Y value in the points table?
2. What are the four extrema points: a query for each is OK
6. The average of the points (i.e. what is the average X and average Y values)
i.e. the centroid (which is not an actual point)
7. The distance of the point that is the closest to the origin (0,0):
8. The point farthest from the origin:
9. The average distance of the points from the origin (0,0)
10. The points that are in the rectangular area bounded by (500,500) (600,500) (500,600) (600,600)
11. The point closest to (666,666)
11b.The average distance from the centroid. Hint: use Set variables.
12. The number of rows in the Cartesian product of the points table with itself.
13. The number of rows in the self-join of the table, using a where clause of p1.pt_id