facility.accdb
| FacilityName | Description | FacilityId | StandardRentalFee |
| Basketball Court | Full High School Regulation Court | 1 | ¤ 35.00 |
| Racquetball Court 1 | Court closest to pool | 2 | ¤ 5.00 |
| Racquetball Court 2 | Court farthest from pool | 3 | ¤ 5.00 |
| Racquetball Court 3 | Old court, upstairs | 4 | ¤ 5.00 |
| Swimming Pool | 6 Lanes, 1 meter diving board and access to shower facilities | 5 | ¤ 100.00 |
| Tennis Court | Court closest to building | 6 | ¤ 10.00 |
| Spinning Room | Back left corner of building | 7 | ¤ 20.00 |
| ReservationNumber | FacilityId | Date | Start Time | End Time |
| 1 | 1 | 10/8/16 | 12/30/99 | 12/30/99 |
| 2 | 2 | 10/8/16 | 12/30/99 | 12/30/99 |
| 3 | 3 | 10/8/16 | 12/30/99 | 12/30/99 |
| 4 | 4 | 10/8/16 | 12/30/99 | 12/30/99 |
| 5 | 5 | 10/8/16 | 12/30/99 | 12/30/99 |
| 6 | 6 | 10/8/16 | 12/30/99 | 12/30/99 |
| 7 | 7 | 10/8/16 | 12/30/99 | 12/30/99 |
SELECT DISTINCTROW *
FROM Reservation;
Dr.Solution11
