SQL: How to use "ORDER BY" and "GROUP BY" together?
<p>I have a database with a list of passengers and the weights of their luggage. I need to display each unique passenger and the total weight of their luggage (passengers can have more than 1 entry for luggage) and display it in descending order.</p>

<p>My current solution that doesnt work is as follows:</p>

<pre><code>SELECT PassengerID, Weight
FROM Baggage
GROUP BY PassengerID
ORDER BY Weight DESC;
</code></pre>