SELECT rel.relations AS relations, res.sailor_ssn AS s_ssn, COUNT(*) AS totalreservations
FROM reservations res JOIN
	(SELECT r1.sailorssn AS from, r2.sailorssn AS to, COUNT(*) AS relations
	FROM reservations r1 JOIN reservations r2 ON r1.boat_reg# = r2.boat_reg#
	GROUP BY (from, to)
	WHERE r1.sailor_ssn != r2.sailor_ssn) rel ON rel.from = res.sailor_ssn
	GROUP BY res.sailor_ssn)
WHERE rel.relations != totalreservations