n-SanDiegoSailing-021.accdb
| BoatID | BoatType | Length | Seats | Sleeps | FourHourRentalRate | FullDayRentalRate | GalleyWithStove | ModelYear |
| 1010 | Catalina 270 | 28'4" | 8 | 6 | ¤ 139.00 | ¤ 179.00 | true | 1994 |
| 1015 | Catalina 270 | 28'4" | 8 | 6 | ¤ 139.00 | ¤ 179.00 | true | 1995 |
| 1146 | Hunter 33 | 33'6" | 10 | 6 | ¤ 299.00 | ¤ 349.00 | true | 2000 |
| 1150 | Capri 22 Mk II | 24'8" | 6 | 4 | ¤ 65.00 | ¤ 89.00 | false | 2001 |
| 1152 | Capri 22 Mk II | 24'8" | 6 | 4 | ¤ 65.00 | ¤ 89.00 | false | 2001 |
| 1164 | Capri 22 Mk II | 24'8" | 6 | 4 | ¤ 65.00 | ¤ 89.00 | false | 2003 |
| 1168 | Hunter 33 | 33'6" | 10 | 6 | ¤ 299.00 | ¤ 349.00 | true | 2004 |
| 1175 | Beneteau 40 | 39'10" | 12 | 6 | ¤ 489.00 | ¤ 529.00 | true | 2005 |
| 1180 | Beneteau 373 | 36'11" | 10 | 6 | ¤ 369.00 | ¤ 409.00 | true | 2006 |
| 1185 | Hunter 36 | 35'6" | 10 | 6 | ¤ 349.00 | ¤ 389.00 | true | 2006 |
| 1190 | Beneteau 373 | 36'11" | 10 | 6 | ¤ 369.00 | ¤ 409.00 | true | 2006 |
| 1200 | Beneteau 373 | 36'11" | 10 | 6 | ¤ 369.00 | ¤ 409.00 | true | 2007 |
| 1205 | Beneteau 40 | 39'10" | 12 | 6 | ¤ 489.00 | ¤ 529.00 | true | 2008 |
| 1225 | Hunter 36 | 35'6" | 10 | 6 | ¤ 349.00 | ¤ 389.00 | true | 2008 |
| RentalID | FKBoatID | RentalDate | FourHourRental? | MemberID | ID |
| 08032 | 1152 | 1/15/15 | true | 1122 | 1 |
| 08033 | 1146 | 1/15/15 | false | 1386 | 2 |
| 08040 | 1010 | 2/2/15 | true | 1122 | 3 |
| 08045 | 1010 | 2/9/15 | false | 1386 | 4 |
| 08046 | 1152 | 2/9/15 | true | 1427 | 5 |
| 08050 | 1152 | 2/15/15 | true | 1122 | 6 |
SELECT SailboatFleet.[BoatID], SailboatFleet.[BoatType], SailboatFleet.[FourHourRentalRate], SailboatFleet.[FullDayRentalRate]
FROM SailboatFleet
WHERE (((SailboatFleet.[FourHourRentalRate])>=450))
ORDER BY SailboatFleet.[FourHourRentalRate];
elcinkara
