sql.sql

select
  count(*)
from
  serial_numbers
join boats on
  boats.id = serial_numbers.boat_id
join boat_sizes on
  boat_sizes.id = boats.boat_size_id
join chassis on
  chassis.id = boats.chassis_id
where
  serial_numbers.value >= '82000'
  and (not boats.cancelled)
  and (not boats.hold)
group by
  chassis.name, boat_sizes.name
order by
  chassis.name asc,
  boat_sizes.name asc