SELECT PassID, COUNT$($FlightID$)$ AS 'NumFlights', SUM$($SeatPrice$)$ AS 'TotalSpent'

FROM Passenger

Right JOIN ManifestPassenger USING$($PassID$)$

GROUP BY PassID

ORDER BY NumFlights DESC, TotalSpent DESC;