i want group the data according to event and find the winner of tournment using pyspark or sql
#spark.sql("select event,winner from chess group by event,winner").show()
dataset link :-https://drive.google.com/file/d/1fb4nyOmYfPjFsrR_222tO38_-DYZWDLA/view?usp=sharing