Data Analyst SQL Interview Question | Amazon | Google | SQL Interview Question

Подписаться 2,1 тыс.

50% 1

In this video we will solve a SQL interview question which was asked in Amazon & Google Data Analyst Interview.
Data :-drive.google.c...
Import Data from Excel file into Microsoft SQL Server
• SQL | Import Data from...
Question :- The election is conducted in a city and everyone can vote for one or more candidates, or choose not to vote at all. Each person has 1 vote so if they vote for multiple candidates, their vote gets equally split across these candidates. Output the name of the candidate or multiple names in case of a tie. To avoid issues with a floating-point error you can round the number of votes received by a candidate to 3 decimal places.
🔍 Looking for something specific? Check out my curated playlists.
✅Complex SQL Interview Questions
• Complex SQL Interview ...
✅SQL Interview Questions
• SQL Interview Bootcamp...
✅SQL Mastery Interview Prep
• SQL Concepts: Detailed...
✅Learn SQL Concepts
• SQL Fundamentals: Key ...
✅SQL Functions
• SQL Functions Explaine...
Don't forget to hit the subscribe button and ring the notification bell to never miss an update! Become a valued member of our passionate community and be part of the journey with me!
Thanks for watching, and see you in the next video!" 🚀

Опубликовано:

3 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 2

@vishalvravi5678 4 месяца назад

Very good.

@Ilovefriendswebseries 3 месяца назад

Another approach WITH cte AS ( SELECT *, COUNT(voter) OVER (PARTITION BY voter) AS voter_cnt, ROUND(1.0 / COUNT(voter) OVER (PARTITION BY voter), 3) AS vote_value FROM votes ) SELECT candidate,sum(vote_value) as total_votes from cte where candidate is not null group by candidate order by sum(vote_value) desc limit 1;