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