Answer the given question with a proper explanation and step-by-step solution. I wrote a spark SQL query that returns the top 100 users, however, I need to show name rather than user_id. What am I missing? My code is shown below: def users_top_100_tip_count(): return spark.sql("""\ SELECT tip.user_id, count(*) as tip_count FROM tip LEFT JOIN user ON tip.user_id = user.user_id GROUP BY tip.user_id ORDER BY tip_count DESC, user_id ASC LIMIT 100 """) example of my expected output: +--------+---------+ | name|tip_count| +--------+---------+ | Weifong| 167| | Alice| 42| | Bob| 42| | Jamal| 3| +--------+---------+
Answer the given question with a proper explanation and step-by-step solution. I wrote a spark SQL query that returns the top 100 users, however, I need to show name rather than user_id. What am I missing? My code is shown below: def users_top_100_tip_count(): return spark.sql("""\ SELECT tip.user_id, count(*) as tip_count FROM tip LEFT JOIN user ON tip.user_id = user.user_id GROUP BY tip.user_id ORDER BY tip_count DESC, user_id ASC LIMIT 100 """) example of my expected output: +--------+---------+ | name|tip_count| +--------+---------+ | Weifong| 167| | Alice| 42| | Bob| 42| | Jamal| 3| +--------+---------+
Chapter9: Joining Data From Multiple Tables
Section: Chapter Questions
Problem 9MC
Related questions
Question
Answer the given question with a proper explanation and step-by-step solution.
I wrote a spark SQL query that returns the top 100 users, however, I need to show name rather than user_id. What am I missing? My code is shown below:
def users_top_100_tip_count():
return spark.sql("""\
SELECT tip.user_id, count(*) as tip_count
FROM tip
LEFT JOIN user
ON tip.user_id = user.user_id
GROUP BY tip.user_id
ORDER BY tip_count DESC, user_id ASC LIMIT 100
""")
example of my expected output:
+--------+---------+ | name|tip_count| +--------+---------+ | Weifong| 167| | Alice| 42| | Bob| 42| | Jamal| 3| +--------+---------+
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning