Answered: Answer the given question with a proper…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions