$--$ Query $4$

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

FROM Passenger

INNER JOIN ManifestPassenger USING$($PassID$)$

WHERE PassID $=283$

GROUP BY PassID

ORDER BY NumFlights DESC, TotalSpent DESC;