Seagul

Lesson 3 - Users with the fewest voting days

Dataset statusEasy SQL exercisesvv1

Exercise content

In the book_stars table, find the user or users who voted on the smallest number of days.

Return:

user_id
active_days

Hints

Hint 1

For each user_id, do not count all rows. Count distinct vote_date values.
Hint 2

After calculating the days for each user, you need to find the smallest value. That minimum must be compared against each user.
Hint 3

You can use HAVING after GROUP BY. The idea is: keep only the users whose count is equal to the minimum found.

Not completed

Loading dataset...

Latest result

No result set available.