#457 Users with More Than a Given Number of Exercises

Companies:

Insyres

Themes:

SQLAggregationPractice

There are two related tables:

User
Id | Name
...

UserExercise
Id | UserId | Name
...

Write an SQL query that returns, in reverse alphabetical order, the names of all users who have more than 5 exercises.

Do not use subqueries.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.