Question Completion Status:

beer$=$'Budweiser', total score $=25$

beer$=$'Heineken', total score $=12$

$($Multiple Choice with Negative Scores for wrong Answers$)$

A$.$ df$.$drop$(\text{'}$drinker$\text{'}).$groupByKey$(\text{'}$beer$\text{'}).$reduceByKey$($add$).$collect$()$

B$.$ df$.$drop$(\text{'}$drinker$\text{'}).$groupBy$(\text{'}$beer$\text{'}).$agg$(\{\text{'}$score$\text{'}$: 'sum'$\}).$collect$()$

C$.$ df$.$drop$(\text{'}$drinker$\text{'}).$groupByKey$(\text{'}$beer$\text{'}).$map$($lambda a$,$ b: a$+$b$).$top$()$

D$.$ df$.$filter$(\text{'}$drinker$\text{'}).$groupBy$(\text{'}$beer$\text{'}).$agg$(\{\text{'}$score$\text{'}$: 'sum'$\}).$collect$()$

E$.$ df$.$filter$(\text{'}$drinker$\text{'}).$groupByKey$(\text{'}$beer$\text{'}).$reduceByKey$($add$).$collect$()$

F$.$ sqIContext.sqI$("$SELECT beer, sum$($score$)$ from drinkers GROUP BY drinker"$).$collect$()$

G$.$ df$.$filter$(\text{'}$drinker$\text{'}).$groupByKey$(\text{'}$beer$\text{'}).$agg$(\{\text{'}$score$\text{'}$: 'sum'$\}).$collect$()$

H$.$ df$.$drop$(\text{'}$drinker$\text{'}).$groupByKey$(\text{'}$beer$\text{'}).$map$($lambda a$,$ b: a$+$b$).$collect$()$

I. sqIContext.sql$("$SELECT beer, sum$($score$)$ from drinkers GROUP BY beer"$).$collect$()$

$|.$ df$.$drop$(\text{'}$drinker$\text{'}).$groupBy$(\text{'}$beer$\text{'}).$map$(\{\text{'}$score$\text{'}$: 'sum'$\}).$collect$()$