CMIS 320
Name:____________________________


Create the GeomPoints database using the geomPoints.sql file.
The red dots of geom.gif are the points (ignore the green rectangles).

0. Paste the Description of the points table:

1. How many points are there:

2. Display the first 10 rows with both fields.

3. Display the first 10 rows, showing the WKT and X and y values of the point column.


4. The largest X, largest Y, smallest X, smallest Y value in the points table?

5abcd. 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)?

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 rectangle bounded by (500,500) (600,500) (500,600) (600,600)

11. The point closest to (666,666)


12. The number of rows in the Cartesian product of the table with itself.

13. The number of rows in the self-join of the table, using a where clause of p1.id<p2.id

14. The maximum distance that any pair of points is from each other.
hint: self-join

15. The pair of points that is farthest from each other.

16. The minimum distance that any pair of points is from each other.

17. The sum of the distances between every pair of points.

18. The average distance between a pair of points.

19. The length of the path from point 1 to point 2 to point 3 ... to point 1000.  
Hints: self-join and a where clause of p1.id=p2.id+1
(It's a very inefficient path...)