Database: boat_1
Question: How many reservations exist for each boat?
SQL:
SELECT bid ,  count(*) FROM Reserves GROUP BY bid