SQL Interview Questions Part 53 | Google SQL Question | SQL Data Engineer Interview | Activity Rank
SQL Interview Questions Part 53 | Google SQL Question Part-10 | SQL Data Engineer Interview 🔥🔥
Write a SQL query to 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.
While displaying rankings , return unique ranks even if multiple users have the same number of emails.
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
🔴 Instagram :
/ itjunction4all
🔴 Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
🔴 Table and Insert SQL Script :
-------------------------------------------------------------------------
Create Table google_gmail_emails (
Id int,
From_User varchar(40),
To_User varchar(40),
Days int
)
**I have provided the INSERT SQL scripts in git repository in below link as there were 315 records.
https://github.com/Sunil-ITJunction4A...
#GoogleDataEngineer #GoogleInterview #GoogleSQLInterview #FAANG #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #sqlInterviewQuestionsForTesting #ITJunction4all
Смотрите видео SQL Interview Questions Part 53 | Google SQL Question | SQL Data Engineer Interview | Activity Rank онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ItJunction4all 30 Июль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,366 раз и оно понравилось 71 людям.