select full_name, count(full_name) as value_occurrence
from reservation r
join individual e on e.client_id = r.client_id
group by full_name
order by value_occurrence DESC