LINQ with Select, OrderBy and Take

Solve a typical LINQ problem using Select, OrderBy and Limit.

Asked in the HackerRank coding challenge (75 minutes) stage. This was the second problem in the 75-minute HackerRank screen and was rated easy.

Use the provided users and user_profiles tables. Return users even when no matching profile exists.

Output

1. One row per user, limited to the five newest users.
2. Columns: user_id, user_name, city, and created_at.
3. Order by created_at descending, then user_id ascending to break ties.