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
Watch video SQL Interview Questions Part 53 | Google SQL Question | SQL Data Engineer Interview | Activity Rank online without registration, duration hours minute second in high quality. This video was added by user ItJunction4all 30 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,366 once and liked it 71 people.