Olympic data spark SQL task Quesion no – 3

This topic has 1 reply, 1 voice, and was last updated 5 years, 6 months ago by DataFlair Team.

Viewing 1 reply thread

Author

Posts
- September 20, 2018 at 3:26 pm #5501
  
  DataFlair Team
  Spectator
  
  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
- September 20, 2018 at 3:26 pm #5502
  
  DataFlair Team
  Spectator
  
  Yes It should be _c6
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.