MySQL Forums
Forum List  »  Newbie

Selection based on Ranking and Weighting
Posted by: Benjamin Rolls
Date: June 15, 2016 04:26PM

How do I 1. select a rank of countries based on number of medals won by measuring the number of Gold(3), silver(2), Bronze(1)

2. select all Countries which won more than the average number of (any) medal across all countries from the table below:

full table below:



http://i66.tinypic.com/2e64xp4.png

Options: ReplyQuote


Subject
Written By
Posted
Selection based on Ranking and Weighting
June 15, 2016 04:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.