For states (col) receiving exactly X number of items (row), sort the items by weight (col)
I finally figured it out!

SELECT State, Weight FROM testing
WHERE State = ANY ( 
    SELECT State FROM testing
    GROUP BY State
    HAVING COUNT(*) = 7
)
ORDER BY Weight DESC;