select FirstName, LastName, count(t.Id)
from Passengers as p
left join Tickets as t on p.Id = t.PassengerId
group by FirstName, LastName
order by count(t.Id) desc, FirstName