Top 10 athletes who won highest gold medals
in all the Olympic event
Answer given as
spark.sql(“SELECT _c0, sum(_c9) as cnt FROM olympic group by _c0 order by cnt DESC”).show
But c9 as as total model , _c6 column as gold medal, I believe we need to look
spark.sql(“SELECT _c0, sum(_c6) as cnt FROM olympic group by _c0 order by cnt DESC”).show