codice:
select p.idvelisti,v.nome,count(distinct(p.idbarche)) as quante
from prenotazioni as p
inner join velisti as v
on v.id = p.idvelisti
group by idvelisti
having quante = (select count(id) from barche)