ar_snippet_sql_3.sql

SELECT
    `captains`.*
FROM
    `captains`
        INNER JOIN
    `boats` ON `boats`.`captain_id` = `captains`.`id`
        INNER JOIN
    `boat_classifications` ON `boat_classifications`.`boat_id` = `boats`.`id`
        INNER JOIN
    `classifications` ON `classifications`.`id` = `boat_classifications`.`classification_id`
WHERE
    `classifications`.`name` = 'Sailboat'