SQL Interview Question - 2 Google- Hard
SQL with POSTGRE.
Question:
Find the email activity rank for each user. Email activity rank is defined by the total number of emails sent. The user with the highest number of emails sent will have a rank of 1, and so on. Output the user, total emails, and their activity rank. Order records by the total emails in descending order. Sort users with the same number of emails in alphabetical order.
In your rankings, return a unique value (i.e., a unique rank) even if multiple users have the same number of emails.
Link to the question is
https://platform.stratascratch.com/co...
SQL interview questions clearly explained with simple terms easy to understand.